Query running from 2 dates in a table

[gmazza76]

Good afternoon,

I have a table where a person enters a "From Date" & "To Date" and I would like to use this table to populate the date range in a few queries, but I seem to be missing something fairly simple.

In my "Call Date" I have the formula below, but I get an error "Your query does not include the specific expression 'dataTable.[Call Date] Between [DateTable]![From Date] and [DataTable]![To Date]' as part of an aggregate function.

Apologies if this is something simple, but I haven't had this error before.

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

thanks in advance

Gavin

 

[ranman256]

use a form (fMyForm) with 2 text boxes: txtStartDate , txtEndDate

the query would then be:
select * from dataTable where dataTable.[Call Date] between forms!fMyForm!txtStartDate and forms!fMyForm!txtEndDate