Two Columns, one for even one for odd

[RJW]

I'd like to create a report with two columns, one column for ID numbers that are even and a second column for ID numbers that are odd

First five rows of my table.
ID, Amount
1, $22,775.00
2, $30,665.00
3, $21,700.00
4, $31,875.00
5, $25,115.00

The start of the report would look like this(without the dots) ...

$22,775.00................$30,665.00
$21,700.00................$31,875.00
$25,115.00

Does anybody know of a way?

Thanks,

RJ

 

[theDBguy]

Hi. Without seeing the rest of your data, you could try setting up a two-column report and simply sort your records by ID. But if you have gaps, then we'll need to try another way, like maybe using two subreports instead.

 

[RJW]

Sub reports. Didn't think about that. That would do it.

Thanks

RJ

 

[theDBguy]

Sub reports. Didn't think about that. That would do it.

Thanks

RJ

Hi RJ. You're welcome. Happy to assist. Good luck!

 

[Deleted member 147267]

I suppose if you're going to use sub form/report an easy type of sql would be

SELECT Table.ID, Table.SomeField 
FROM Table WHERE [ID] Mod 2 = 0;

Use [ID] Mod 2 <>0 for odd numbers

 

[Pat Hartman]

reports have a column option. Sounds like two columns with "over then down" orientation. No code required.