Lauren, take a look at this example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
It illustrates how to build the criteria from just the boxes where the user
entered some values to filter by, covering different types of data, exact
matches and wildcards, and ranges (from and to values.)

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> please help,
>
[quoted text clipped - 5 lines]
> I would appreciate any help,
> Thanks