Query Criteria

F

FJB

Is it possible to have multiple fields with criteria at the same time
so that wehen you run the querey a window with all of the options
appears? I have a situation where the users need to be able to query
the database by a transaction number OR a name. Thanks for your help
 
M

[MVP] S.Clark

You can create your own form, and have the query refer to the form.

Such as:

SELECT * from Tablename where StartDate between Forms!formName!txtStartDate
And Forms!formName!txtEndDate

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting
 
Top