Help with passing a date into a "between" expression

[schreibman]

I have a query with an expression as follows in criteria:


Between #1/1/2012# And #1/1/2012#

I want to pass into that expression a value from another table.
So, I created a table, DateRange, with fields StartDate and EndDate

Then, I modified my expression as follows:

Between [DateRange]![StartDate] And [DateRange]![EndDate]

Which, of course, didn't work, as the expression didn't know which 'row' to use.


I'm sure there is something very easy I am missing, but I am a raw access novice, so any help is appreciated!

[Bob Fitz]

Can you post the SQL statement of the query.

[schreibman]

...

where (((CallLog.Date_Call_Began) between #1 / 1 / 2012 # and #1 / 1 / 2012 #));

[alansidman]

Look at this video as it may be helpful

http://www.datapigtechnologies.com/f...earchform.html

You will need to adapt it for your date needs, but it should get you on the right path.

[schreibman]

Look at this video as it may be helpful

http://www.datapigtechnologies.com/f...earchform.html

You will need to adapt it for your date needs, but it should get you on the right path.

Awesome ! What a great resource! Exactly what I needed, and more!