Merging columns on Reports

  • Thread starter Thread starter Flintstone
  • Start date Start date
F

Flintstone

I have a crosstab query I am using for a report. The problem is that I
would like to merge 3 columns into one.

Query results:
Date Electricity Tel Garden
1.1.2006 100.00
1.1.2006 10.00
1.1.2006 60.00

Report should display:
Date Electricity Garden
1.1.2006 100.00
1.1.2006 10.00
1.1.2006 60.00

In other words the Tel and Electricity fields should be merged into the
Electricity field.

I expect I can do this with a statement in control source but I have
not been able to work out how. I have tried typing =IIf([Gem] > 0,
[Gem], Null) to start doing this but as soon as I leave the Control
Source field I receive an error stating that 'The method you entered
contains invalid syntax'.

I am using Access 2003 ... Does anybody know what I need to do?
 
Oops, I meant to say that I have tried typing =IIf([Electricity] >
0,[Electricity],Null)
 
Did you try:
=Nz([Electricity],0) + Nz([Tel],0)
Make sure the name of the control is not Electricity or Tel.
You can use the Format property to hide the 0 values.
 
I cannot believe it ... the reason I could not get it to work is
because this PC is set up for German (Switzerland) regional settings,
they use a semicolon instead of a comma as a deliminator even in csv
files.

=Nz([Electricity];0)+Nz([Tel];0) works fine

Thanks for the help
 
Back
Top