How do I create all columns in a macro.

G

Guest

Hello

I am trying to create a report like the one below but I am having difficulty.

Balances EUR GBP USD
Broker 1 10.00 10.00 15.00
Broker 2 15.00 10.00 10.00

Broker 3 10.00 5.00 5.00
TOTAL 35.00 5.00 30.00

Instead of Keep getting the following report.
Balances EUR GBP USD
Broker 1 10.00 Broker 1 10.00 Broker1 15.00
Broker 2 5.00 Broker 2 10.00 Broker 3 10.00

How do I stop Broker showing each time.

MANY THANKS
 
A

Al Camp

GOS,
Are you using 3 "Columns" to get the display you indicate. If so, that's why the
"Broker" repeats.
Use a Crosstab query instead. Broker as Row, Currency as Column, and Amount as Value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I put multuple columns in a report 1
Textbox Controls in Reports 2
Total Column Sum for Multiple pages on Multiple Pages 1
Grand total of a group 1
Create rows from a lookup 3
Calculations in Reports - adding two totals 1
combine vlookup and match help 5
how do i convert a row of data into a column in another excel wor. 1

Top