Create Date From - To Lookup From Table

[abbaddon223]

Hi,

I'm buliding a reporting suite which will primarily run by initially asking for a From Date & To Date.

I'm fine to put this into a query, however as there will be multiple proceedures before the end result, I don't want my users having to put in a Date From & Date To each time a new proceedure executes.

I've tried buliding an expression into a query to look at a table with the fields [FromDate] [ToDate] in it. The expressions is

Between [tb_From_To_Date_Project]![Date From] And [tb_From_To_Date_Project]![Date To]

This just throws back a Parameter Value request...

I'm now stuck - any help greatly appreciated!! Thanks.

 

[Galaxiom]

It should work if you name the fields in your query to match those in the table.

WHERE [somefield] Between [tb_From_To_Date_Project]![FromDate] And [tb_From_To_Date_Project]![ToDate]

 

[abbaddon223]

Hi,

Thanks for the response.

Do you mean in the criteria line in the query or as a SQL statement in a module?