Results 1 to 2 of 2
  1. #1
    blkdragon201 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    4

    Query Suggestion?

    I have included a link at the end of this thread to download and open my test database.
    I have currently structured it with One field that has an Item ID name (for every item i currently sell). And the rest of the fields are just customer names. I have a check box for each item code that corresponds to each customer name. and if there is a check in the box that means the customer owns the item already.
    I was wondering how i would build a query where it shows one specific Item ex: wbc101, and which customers have a check in the box for that item code.
    In other words, Say i want to see only people who HAVE the item wbc101, and exclude customers that don't have it (not checked). How would I get that to happen with a query?
    Sorry if its unclear. but once you see the Database I have structured i hope it makes sense.

    Thanks!
    DB: http://www.4shared.com/file/Y6hHMfds/Test1.html


    (Sorry I couldn't make it an attachment. There is a 500kb limit )

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you Compact and Repair your db and then zip it up, the limit is 2MB's.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. I need suggestion in SQL
    By genesis in forum Access
    Replies: 0
    Last Post: 07-31-2009, 08:17 PM
  2. Need suggestion or help please
    By KLynch0803 in forum Programming
    Replies: 14
    Last Post: 06-11-2009, 10:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums