Dates, Textbox and Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]!
Click to expand...
[control2]
if the form is not open, you will be prompt for the date
parameters.
Regards
Frank
 
Back
Top