| Title: | MSACCESS |
| Moderator: | BUMP::HONER |
| Created: | Tue Dec 01 1992 |
| Last Modified: | Mon Jun 02 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1661 |
| Total number of notes: | 6339 |
my queries and reports are as follows:
qry_LeadBySup fields Lead Name rpt_LeadBySup - all fields
Accepted(Y/N) monthly
Created Date grouped by Rep Name
Rep Name grouped by Supervisor
Supervisor
qry_LeadBySup2 fields same rpt_LeadBySup2 summary data
QTD
grouped by Rep Name
grouped by Supervisor
I want to print total Accepted Leads by Rep on Report 1 Sum(A_cnt) for the
month
I want to print total Accepted Leads by Rep from Report 2 for the
quarter on the same report.
I want to use the DSUM function....
What is the correct syntax for the DSUM function is this case?????
DSUM("[A_CNT]","qry_LeadBySup2",**********) how do you specify
that the Rep Name field from both be the same
Any suggestions would be helpful or you may call me for further
explanation if you want - 804 795-9274.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1638.1 | BUSY::SLAB | Do ya wanna bump and grind with me? | Thu Mar 06 1997 10:42 | 6 | |
Why not do it all on 1 report and just change the sorting such
that you can see all of a single Rep's data together?
Sort/group by rep, then by quarter, then by month.
| |||||
| 1638.2 | still confused | GRANPA::LGRAY | Thu Mar 06 1997 11:13 | 6 | |
I need the detail of the report to show only the current month
How can I have a query with the all the quarters data but only
show a months detail in the report
I need a monthly report with QTD summary data grouped by the
rep and then the supervisor
| |||||
| 1638.3 | BUSY::SLAB | Dogbert's New Ruling Class: 150K | Thu Mar 06 1997 12:51 | 28 | |
If you're just looking to print a bottom-line number for each Rep
[IE, total by month and total by quarter] then you can report off
of the same query with an output that looks something like this:
Supervisor1:
Rep1 SumOfMonth SumOfQuarter
Rep2 SumOfMonth SumOfQuarter
Rep3 SumOfMonth SumOfQuarter
Supervisor2:
Rep4 SumOfMonth SumOfQuarter
Rep5 SumOfMonth SumOfQuarter
Rep6 SumOfMonth SumOfQuarter
Sort data by Supervisor, then by rep [with a footer which includes
the fields to be totalled], then by quarter and then by month.
But I guess you only want to see the current month's total while at
the same time see the entire quarter's total? If the data is sort-
ed by month, the last month listed per rep will always be the most
recent month ... not good enough?
| |||||
| 1638.4 | THANKS FOR THE HELP | GRANPA::LGRAY | Thu Mar 06 1997 14:50 | 6 | |
THANKS, THAT METHOD WORKED FINE.....
I MADE A SEPARATE QUERY THAT SUMMED THE QTD COUNTS
I LINKED THAT QUERY TO MY MAIN QUERY...
AGAIN, THANK YOU FOR YOUR IDEAS....
| |||||