1 for the guru's & MVP's

  • Thread starter Thread starter noodnutt
  • Start date Start date
N

noodnutt

G'day,

I have a report with 2 columns setup quite nicely with totals in the report
footer.

What I need to know is if there is a way of totalling each column
seperately.

Column.1 Column.2

Abc 10.00 Cde 15.00
bcd 20.00 fgh 30.00
xyz 50.00

Total: 80.00 Total: 45.00

TIA

Mark.
 
The method that I would attempt involves using two subreports, one for the
left and one for the right. This assumes you can differentiate these records
into two distinct groups.
 
Thx for your thoughts Duane, you have given me idea, how about:

Left Column: Right Column:
recorddate>1<17 recorddate>16<31

I could then run 2 queries with the date parameters set as above using them
as my subreport.

Thx again Duane, very helpful.

Reg's
Mark.
 
Just a follow up on my previous post.

I created the 2 queries:

qryTimeLC = <17 & qryTimeRC = >16

The report works quite well except I need to expand on it a little more, for
instance:

If a contractor only does a few days with us, then I only need a standard
report as opposed to another contractor who 50+ jobs in a month, which I
would use the new dual column report.

The only problem I have at present is filtering the month as the popup comes
up twice, once for each query, also, do you have an idea for a command to
select either report (single column or dual) given the amount of records per
month, e.g.

If "qryTimeLC.RecordCount>50 then
DoCmd.OpenReport "rptTime2
Else
DoCmd.OpenReport "rptTime1

Not sure if that is the correct syntax, but you may get the idea.

Looking forward to your thoughts.

TIA

Reg's
Mark.
 
Back
Top