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.

Help with Access 2000 (querys)

Discussion in 'Business Applications' started by Access2k, Nov 12, 2007.

Thread Status:
Not open for further replies.
  1. Access2k

    Access2k Thread Starter

    Joined:
    Jun 24, 2004
    Messages:
    54
    HI everyone,

    I created a form where the users will enter values that I used on a query and then I put the data in a report. All the fields on the form start with an "*", the user can leave it like that or enter a value. my problem is that there is a field that can be Null... since I have an "*" then I am not getting those records. Is there a way to do check for nulls.

    This form allow a user to enter 4 codes or just use a "*" to get all codes but I am using 4 queries and 4 report is there a way that I can check if there is a value on code one use one query with only that code but if they enter two codes to use the same query with those two codes. I have 4 text box.

    Thanks.
    AMD2800
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
  3. Access2k

    Access2k Thread Starter

    Joined:
    Jun 24, 2004
    Messages:
    54
    Ahggg... Sorry I did not see the form option yikess I am sorry for wasting everyones time. I will make sure I see my old notes before i post.

    Thanks you.

    AMD2800
     
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/650967

  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