Query Criteria

[FrankMars]

I have written the following on the criteria line of my query;

(Between [Forms]![zzfaCriteriaForm]![tbxPriceFrom] And [Forms]![zzfaCriteriaForm]![tbxPriceTo]

Im unable to get all records if nothing is filled out in the tbxPriceFrom and tbxPriceTo fields on my form. What am I doing wrong? Thank you in advance.

 

[randy700]

Use default values.


Randy

 

[dhookom]

You can try:

Between Nz([Forms]![zzfaCriteriaForm]![tbxPriceFrom],#1/1/1900#) And Nz([Forms]![zzfaCriteriaForm]![tbxPriceTo],Date()+9999)

Duane
Hook'D on Access
MS Access MVP

 

[FrankMars]

The code worked - thanks.