R
REGREGL
I have a query that returns values for order in different states of
completions for two different companies. For example: on 10/14 we may have
3 orders transmitted, 2 orders queried and 4 orders fulfilled for Company A.
Also on 10/14 we have 2 orders transmitted, 0 orders queried and 3 orders
fulfilled for Company B. I would like the report of this query to show these
totals on 1 line per day (like on a spreadsheet) So, you would have column
headings of Company A Orders Transmitted, Company B Orders Transmitted, Total
Orders Transmitted, Company A Orders Queried, CompanyB Orders Queried, Total
Orders Queried, Company A Orders Fulfilled, Company B Orders Fulfilled &
Total Orders Fulfilled. The row headings would be date & the values would be
the total applicable values for each column heading.
I have gotten the appropriate column headings and values. The problem is
that when I put those text boxes in the Detail section, I receive 2 records
(1 record with tootals from each column heading per Company). If I put the
text boxes in the Date Header section the report only shows the first record
for the day (or in other words, only the totals for one company) and ignores
any additional records.
How can I combine both companies totals into one line per day?
I am pulling my hair out as I type.
completions for two different companies. For example: on 10/14 we may have
3 orders transmitted, 2 orders queried and 4 orders fulfilled for Company A.
Also on 10/14 we have 2 orders transmitted, 0 orders queried and 3 orders
fulfilled for Company B. I would like the report of this query to show these
totals on 1 line per day (like on a spreadsheet) So, you would have column
headings of Company A Orders Transmitted, Company B Orders Transmitted, Total
Orders Transmitted, Company A Orders Queried, CompanyB Orders Queried, Total
Orders Queried, Company A Orders Fulfilled, Company B Orders Fulfilled &
Total Orders Fulfilled. The row headings would be date & the values would be
the total applicable values for each column heading.
I have gotten the appropriate column headings and values. The problem is
that when I put those text boxes in the Detail section, I receive 2 records
(1 record with tootals from each column heading per Company). If I put the
text boxes in the Date Header section the report only shows the first record
for the day (or in other words, only the totals for one company) and ignores
any additional records.
How can I combine both companies totals into one line per day?
I am pulling my hair out as I type.