1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Quick Access Question

Discussion in 'Business Applications' started by Kammmie, Sep 9, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Kammmie

    Kammmie Thread Starter

    Joined:
    Aug 14, 2001
    Messages:
    132
    If I want to run a report to show ONLY orders that have not been delivered yet how would I set the criteria?

    Kristy
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,294
    First Name:
    Wayne
    depends on how you have set your table up - but you could look for records which have a null delivery dates. - that will only provides records with no delivery date
    how do you know in your tables that a delivery has taken place.
     
  3. Kammmie

    Kammmie Thread Starter

    Joined:
    Aug 14, 2001
    Messages:
    132
    We enter in the form when an order has delivered. What would I put in the criteria of the query? Criteria = null ??
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,294
    First Name:
    Wayne
    yes - if the cell is full of nulls
    if its a date field sometimes it can use a default date of something like 1-1-1904 cant remember exactly in access
    run a query and set a row limit and see what you have in the field when blank
    try a tst using = null
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/272109

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice