A while back I created a Base file and was able to run queries successfully. It’s been a while since I initially created it and while it works for data entry I’m having problems getting my queries to work now. Hoping someone can pinpoint my mistake?
So, I am in the Querries area and I select “Create Query in Design View”… To make this easy I bring up 1 column that has 5 entries that are spelled numbers: one, two, three, four, five…
I add the data field containing the numbers and under “Criteria” I type in the following to query the number “two”:
I then hit the run icon…and the result comes back with all 5 numbers… or everything in the column…instead of only the number two…
Where am I going wrong?
I’m using LO Version: 126.96.36.199 and Windows 7.