flexible query

  • Thread starter Thread starter marci
  • Start date Start date
M

marci

hi i have a database with a table with different fields country, address,
name etc
i need to buid a query where i can select as a criteria each time either
criteria from one field, two three or more.
anyone can halp me? maybe i need to use modules?

thanks
 
You would have to give us more specifics, but you could put criteria like
the following if you want it to ask the user...

Under NAME put something like the following...

like "*" & [Enter Partial Name / Blank for all] & "*"


Under the ADDRESS field put...

like "*" & [Enter Partial Address/ Blank for all] & "*"


etc.



Rick B
 
actually i need to build a serach form with the field like the ones in the
table and then be able to serach in the table according with the criteria
that will be put in the field, criteria will change for each search,
thanks for your help
 
Well, build you r form and then use the fields from the form as the criteria
in your query. Basically, do the same thing I mentioned in my previous
post, but get your data from the form fields (instead of from a user
prompt).

Do some searches for more details, as this is a pretty common request.

Rick B
 
Back
Top