wheres the data? (1 Viewer)

[mikevaughan023]

i have a form, which opens the query in design view, when the button is pressed. i enter the criteria, and the criteria is all correct. but when i run the query, it shows the table, but no data is shown. i had a fiddle about with the querey, and figured out when i press the A-Z button, the filtered data is shown. ??????
can some 1 help me!!

 

[jwindon]

Sounds as though your query is not properly set.

There is a sort option on the query grid. But what I'm wondering is if you have a join issue that is returning "extra" records??

Is your join strictly equal join?

Also, it is probably not necessary to open the query in design view. If you ellaborate on the specific criteria you are entering, the forum could assist you in this.