Return all records with multiple parameters

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I have a query with two fields that I'm using parameters
on. The first field is an account number and the second
field is an activity date field. I want to be able to 1)
key in an account number and a date range to find specific
records or 2)key in an acccount number and find all
records for that account, or 3)see all records. For the
account number field on the criteria row I have [Account
No] and a separate field with [Account No] as the field
name and on that same field Is Null on the or row. For
the activity date field I have Between [Start Date] and
[End Date] on the criteria row and a separate field called
[Start Date] with Is Null on the or row. Can any one give
help with this quesions? Thanks in advance.
 
The parameter query isn't that sophisticated of a feature to perform all of
that.
Anything more than one parameter, especially if any OR conditions exist, I
build a form, then use VBA to create the SQL string.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top