entering criteria for a parameter querey

A

Access WannaBe

I have a form that allows users to enter criteria in a querey. The
expression I use is:

Between [forms]![f overstock]![BeginningStock] And [forms]![f
overstock]![Endingstock]

I would like the querey to return all records if the user doesn't enter any
criteria.
 
M

Michel Walsh

Between NZ([forms]![f overstock]![BeginningStock], #01/01/1900#)
And NZ([forms]![foverstock]![Endingstock], #1/1/3000#)


is a possible solution (kind of supplying a default value) in many cases.



Vanderghast, Access MVP
 

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

>=[BeginDate] And <=[End Date] 1
IIf statement in query criteria 3
Multiple Parameter Crosstab query filter by form 1
Query Criteria part 2 2
Parameter Criteria from a forms Text box - 2003 - not working 5
Entering criteria from form 2
Creating a drop-down list to select and run a query 12
Query Parameter Syntax 2

Top