Two Columns, one for even one for odd (1 Viewer)

RJW

Registered User.
Local time
Yesterday, 20:10
Joined
Sep 21, 2006
Messages
38
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

I’m here to help
Local time
Yesterday, 17:10
Joined
Oct 29, 2018
Messages
10,796
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

Registered User.
Local time
Yesterday, 20:10
Joined
Sep 21, 2006
Messages
38
Sub reports. Didn't think about that. That would do it.

Thanks

RJ
 

Micron

AWF VIP
Local time
Yesterday, 20:10
Joined
Oct 20, 2018
Messages
3,172
I suppose if you're going to use sub form/report an easy type of sql would be
Code:
SELECT Table.ID, Table.SomeField 
FROM Table WHERE [ID] Mod 2 = 0;
Use [ID] Mod 2 <>0 for odd numbers
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 20:10
Joined
Feb 19, 2002
Messages
29,007
reports have a column option. Sounds like two columns with "over then down" orientation. No code required.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom