I have a table 'tblRateHistory' that has a field 'Rate EDU' that I'd like to pull the data from using a date field named 'Effective' (from the same table).
In a query I have a table 'tblBillingLog' that I will use to evaluate if 'Effective' is between date fields [Period Start] and [Period End] from the tblBillingLog.
In my query I have a field with the following syntax:
RateLookup: DLookUp("Rate EDU","tblRateHistory","[Effective] Between #" & [Period Start] & "# AND #" & [Period End] & "#")
When I run it I get #Error in that field and when I click on the field I get the following error
Syntax error (missing operator) in query expression 'Rate EDU'.
What am I messing up??
Thanks!
In a query I have a table 'tblBillingLog' that I will use to evaluate if 'Effective' is between date fields [Period Start] and [Period End] from the tblBillingLog.
In my query I have a field with the following syntax:
RateLookup: DLookUp("Rate EDU","tblRateHistory","[Effective] Between #" & [Period Start] & "# AND #" & [Period End] & "#")
When I run it I get #Error in that field and when I click on the field I get the following error
Syntax error (missing operator) in query expression 'Rate EDU'.
What am I messing up??
Thanks!