Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    32

    Unanswered: Query Dates for Multiple Fields

    Hi all,

    I'm trying to create a label printing query for a mail order system that looks in a table for the date and also how it was sent.

    The tables I'm using are: Customers and CurrentOrders (customer details appear on CurrentOrder table).

    CurrentOrder table is set out as follows:

    ID, Customer (linked to surname and address), DateRec, HowRec, Status, DateSent, HowSent, ToFollowSent, ToFollowHowSent

    I'm currently have a system where it displays info for those being sent on a date entered and a courier entered (eg - 12/11/10 and Company1). It works.

    However, a customer might be having a to follow sent out on the 12th with Company1 as well, no matter how I've tried, I just can't get it to work. I've had the same syntax entered in DateSent and HowSent to the ToFollow fields but it doesn't work, it ends up displaying no information.

    Could someone please help me with this? Thank you

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It is likely a normalization issue to have the numerous date fields in one record, but this type of thing:

    WHERE DateRec = #12/11/10# OR DateSent = #12/11/10# OR ToFollowSent = #12/11/10#
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •