Recent content by locchio

  1. L

    'Between with And' Error

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

    'Between with And' Error

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

    'Between with And' Error

    Brain fart. Thanks!
  4. L

    'Between with And' Error

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

    Solved DLookup Issue

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

    Solved DLookup Issue

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

    Solved DLookup Issue

    Thank you.
  8. L

    Solved DLookup Issue

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

    Solved DLookup Issue

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