Dates, Textbox and Queries

[Guest]

Hi, have a question and hope you can help me out.

I have a form with two dates on it and I want to find the record that fall
between these dates.

My problem is that when I am creating the query, my syntax is messed up.
I'm using the design view and would like to use 'between' the two dates. I
need to get the #'s so access know that there are dates that it is working
with.

Any suggestions would be appreciated. Let me know if I didn't explain it
well.

Harv

 

[Frank Stone]

hi,
Put this in your criteria pane. it will call the 2 dates
in your form. you wont need ##.

=[Forms]![yourform]![contol1] And <[Forms]![yourForm]!

[control2]
if the form is not open, you will be prompt for the date
parameters.
Regards
Frank