Results 1 to 2 of 2

Thread: Crosstab Query?

  1. #1
    Join Date
    Aug 2006
    Posts
    27

    Unanswered: Crosstab Query?

    I have a bound subform that has one field that is grouped and then I have two fields that get sums based on that field. So I want to list all of the part numbers that were produced, for each part number I need a qty for each shift for a particular production line for date ranges like daily weekly, monthly. I get the date range and line number from the main form. Do I need to use a crosstab query, dsum, query in query? I'd appreciate the help. I might be making it harder than it is.

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi Mark
    Just a question to get my brain working.

    Is the crosstab sourcing the data directly from the tables concerned OR is is sourced from a main query which is compiling the data in a logical format?
    Gareth

Posting Permissions

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