querie Criteria date range and find records on ProductType

[Rodrigo R via AccessMonster.com]

I need a Criteria that gives me a date Range, and in that date range finds
matching ProductType
but when I run the querie, if i do not type a ProductType, just type the date
range, I want the querie to return all records in that date range,
i try under date: Criteria Between [enter begining date] and [enter
end date]
and under ProductType Criteria Like [enter Product Type] or is null [
enter Product Type]
but it does not work because if i don't type a ProductType it returns all
Records in the Database not in the date range that I ask for.

 

[Guest]

Use this --
Under date: Criteria Between [Enter begining date] and [Enter end
date]
Under ProductType Criteria Like [Enter Product Type] & "*" or is null

If you press the Enter key without entering a Product Type it will still work.