Parameter Question

  • Thread starter Anthony Viscomi
  • Start date
A

Anthony Viscomi

I have a Qry with 20- 30 fields; I would like to allow the user to query off
any one of those fields using thier own criteria. Is there an easier way to
do this without creating multiple queries?

Thanks!
Anthony
 
G

Guest

no. sorry. you may have to write a query for each criteria
you want. it can be done with the heavy dute SQL but the
Where clause would be 5 miles long.
sorry. no real easy way out of this one.
 
J

John Vinson

I have a Qry with 20- 30 fields; I would like to allow the user to query off
any one of those fields using thier own criteria. Is there an easier way to
do this without creating multiple queries?

Thanks!
Anthony
Click to expand...

Anonymous is mistaken... but not too far wrong. It's possible, but
your best bet would be to use Query by Form. The alternative is a huge
(possibly too big to work) query with criteria like

=[Last Name:] OR [Last Name:] IS NULL

for each of the 30 fields; or to create a Form with thirty controls
(textboxes, and combo boxes or checkboxes if possible) for the thirty
criteria. This Form would then have VBA code to loop through the
controls adding to a SQL string for each non-empty control.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top