Report Design Question

[Parra]

I have a query that gives me

Account Name
Revenue
2002
2001

I need the report to be formatted like this:
2002 2001
Account Name Rev 2002 Rev 2001

Using the wizard the report it formats it like this:

Account Name 2002 Revenue
2001 Revenue.

How can I have it formatted like my first example???
Thanks

 

[Corticus]

Don't use the wizard! LOL

Its kind of hard to explain, really you just view the report in design view and arrange the fields like you want. You usually want to put your field labels in your report or page header, to keep them from repeating for every record.

Check this out, just view the report:

Report Example

HTH,

 

[Parra]

I'll do as you recommend and use the design view.

I tried to open the file but was unable to. I'm using Access 97.

Thanks for all your help!

 

[Corticus]

I converted it to a '97 file.

Try again if you still need some help.

Corticus
www.TheIllumni.com
www.TheOfficeExperts.com

 

[Parra]

Thank Corticus, Maybe you can help, I already designed the report and need the revenue generated by each client next to their name.

So in the detail I have 2 boxes, one that will give me the 02 data and the other 01. I created an if function but I don't think it is working.

=If([year]="2002",[SumOfREVENUE],0)

=If([year]="2001",[SumOfREVENUE],0)

What could be wrong. I really appreciate this. Thanks

Can I even use if functions?

 

[Parra]

OK, I figured it out. It took some time, but I guess its the company's time and not mine. In case you are interested here is the formula:

=IIf([year]=2002,[SumOfREVENUE],"0")

The problem was, I had the text box name the same as "SumOfRevenue". So I was getting an ERROR message.