Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report and Query (2000)

    Good morning,

    i have a report that is based upon a query.

    The query has the following values:

    DateOrdered - Date field
    DateEPC - date field
    DateRec - date field
    Web - Yes/No field
    Sales - Yes/No field
    RM - Yes/no field

    The report is on a tool bar to open. I want to be able to only display the items in the query/report that do not have an entry in all the field specified above. Even if one does not have a entry I want it to be displayed.

    How would I achieve this?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report and Query (2000)

    Yes/No fields always have a value - either Yes or No. They cannot be blank (null, empty). So I assume that you want to look for records with No in one of those fields.

    Set the criteria in the query as follows:
    - Enter Is Null in the DateOrdered column in the first criteria row.
    - Enter Is Null in the DateEPC column in the second criteria row.
    - Enter Is Null in the DateRec column in the third criteria row.
    - Enter No in the Web column in the fourth criteria row.
    - Enter No in the Sales column in the fifth criteria row.
    - Enter No in the RM column in the sixth criteria row.

Posting Permissions

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