Recent content by locchio

I'm not sure how to set it up.. too much crap going on in it.. idk

What am I missing? OMG.. too many hours working on this DB today ON tblMeetingDates.MeetingDate >= tblCustomerMailing.LetterDate+3 and tblMeetingDates.MeetingDate=< tblCustomerMailing.LetterDate+30

Brain fart. Thanks!

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

It won't happen with the data I am using. One rate per zone per time frame.

Brilliant! So simple, but my brain was not wrapping around how to pull the data. I have done similar to edit queries, but just never thought of using it for a range. Clever. Thanks!

Thank you.

Thanks. I should know better. It worked... MORE COFFEE!

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