Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting Query (Access 2000)

    I have done this sereral times, but for some reason, I am stumped. I have one query that counts the amount of records, grouped by dealership. The I have another query which I want to show all dealerships and the amount of records each dealership has submitted (even if the dealership has submitted none), but I cannot get it to work. I hae tried all joins types, but the only dealerships that show are ones that dealerships have submitted. I need to get all dealership to show in the results.

    Thanks

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Counting Query (Access 2000)

    Well, we probably need a bit more detail to give much help, but as a general approach, you want a query which does a Left Join from the dealership table to the submission records. You could then use the Nz function or an IsNull() function to convert null value joins to zero so you get a sum for each dealership. If this doesn't help, post some details about the tables involved and your stab at the query (in SQL view).
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Query (Access 2000)

    Thanks, that was it [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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