Parameter Query Problem

Hi

New to this forum so I would appreciate any help
I have a query that selects between two dates and a specific
product type, this query is run from a form, with a combo box
holding all of the products so when you access the form you
enter the start date and end date and the product type and
access shows you all orders for the product between those two
dates. What I would like the form to do is if the product combo
box is left blank that it will return all orders between those two
dates. I have tried using the Is Null command but the datasheet
that is returned seems to show all records, with the pertinent records
on top and the rest underneath. I know this is probably an easy question
but can someone please help?

Hi Jim,

Can you post the sql of your query? There are several ways to do this, but to avoid confusion if I see how you have your sql written, then it will be easier to help solve it.

lwells