automatic queries

[tinoco]

Hello!
I have a form to list information from the database. The form have 9 fields where the user can introduce different kind of data, age, zip code, country, city,...and a
according with the entering data i will call a specific querie, that means that if the user introduce just the age and the zip code its a querie if he introduce country and age its another. So i have a lot of criterias combinations..
I want to know if exists any possibility to make all this queries automaticaly or if it is necessary to do them one by one.
thank you a lot

 

[PHV]

Do a keyword search in the access fora for qbf
Note: QBF stands for Query By Form

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tinoco]

hello!
i use the format function.
exemple:
format([tablename]![field];"ww")between format(startdate;"ww") and format(finishdate;"ww")
i hope this can help
thank you