Results 1 to 2 of 2
  1. #1
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Query for each category

    I want to run a query for each of the attachment categories of: Nzltr, Rpts, Images, PR, Articles.



    My first query I asked for Nzltr category, but it gives me a bunch of Nzltr categories with the number 0, meaning there is no attachment. How can I get it to return only the field that has an attachment? In other words, I want the attachment field that says [1] or sometimes [2] returned, not the one that says [0]. Thanks for your help on this.
    Click image for larger version. 

Name:	Categories.jpg 
Views:	8 
Size:	167.5 KB 
ID:	8334Click image for larger version. 

Name:	2.jpg 
Views:	6 
Size:	143.9 KB 
ID:	8335

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I cannot read your screen prints, but if I understand your correctly, can't you just add criteria to your query under the Nzlter field that says:
    Code:
    <>0

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

Similar Threads

  1. Count number of defects per category
    By HeadGasket in forum Queries
    Replies: 5
    Last Post: 02-10-2012, 04:13 PM
  2. updating category/subjects
    By jalal in forum Access
    Replies: 2
    Last Post: 02-07-2012, 01:42 PM
  3. Replies: 10
    Last Post: 12-24-2011, 03:37 PM
  4. Category redesign
    By squirrly in forum Database Design
    Replies: 16
    Last Post: 12-13-2011, 06:32 PM
  5. Replies: 0
    Last Post: 08-19-2008, 11:12 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