1 for the guru's & MVP's

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.
 
D

Duane Hookom

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.
 
N

noodnutt

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.
 
N

noodnutt

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.
 
D

Duane Hookom

Don't ever use parameter prompts in queries. Reference a control on a form.
 
Top