query problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i added a criteria to my query, example (in the Name field, like
"form_frmApplicants.txtSearch"). this text field is where i input the name.
but it doesn't work. before it was (in the Name field, like [Enter Name]),
w/c works fine but there are 2 instances of them appearing the (Enter Name).
an underlying query is in the subform's source object. when i click the Name
button the underlying query changes in the subform's source object w/c i
intentionally did to show all the names starting for example with "A". what i
want to eliminate is the 2 instances of them appearing, or is there any work
around solution to this? please help. thanks!
 
Hi,


If you use LIKE, you probably want to include a wild card, * or %. It is
possible that your previous version was requiring * and now required % (or
? and now, required _ ).


If you have duplicated record, try a DISTINCT, as in

SELECT DISTINCT f1, f2 FROM ...


If that does not answer your question, can you reformulate it?


Vanderghast, Access MVP
 
Back
Top