Query Criteria

  • Thread starter Thread starter FJB
  • Start date Start date
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
 
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
(e-mail address removed)
www.fmsinc.com/consulting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

entering criteria for a parameter querey 1
Access Dcount (multiple criteria) 3
>=[BeginDate] And <=[End Date] 1
Use In() Expression as Query criteria with guts from Function 1
Set Query Criteria based on selection from Form 1
Criteria for select query. 2
Not like query criteria 4
Criteria in a Querie 8

Back
Top