Search results

I'm getting a 'between without and' error when I run this query. I am trying to return MeetingDate from tblMeetingDates where the MeetingDate is between 3 days and 30 days older that the LetterDate field in tblCustomerMailing. I tried brackets and parenthesis I still get the error. Thanks for...

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...