Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Moorpark, CA
    Posts
    104

    Unanswered: Difficulties with Count Query

    Ok - I have a db that has one main table with a few tables linked (one to many) with that table. Each smaller table has a few fields that require a date to be entered. I want to count the number of records for each field that has a date entered with the results grouped by customer. I know how to create the query that would count that for each individual small table - the problem I'm having is whether I can create one big query that will combine all the information for one customer on one line. If it isn't possible to do it with a query, can I create a report based on multiple queries that will lay the information out as I specified.

    Thanks for any help you provide!

  2. #2
    Join Date
    Sep 2004
    Posts
    63
    Hi,

    See attachment

    Don't know if this is any good but I did this using a Union Query.

    qryDateTotals shows a count all dates for the tables

    qryListDates shows a list of the dates.

    ChrisOfCatford
    Attached Files Attached Files

Posting Permissions

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