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

RJW

Registered User.
Local time
Today, 14:51
Joined
Sep 21, 2006
Messages
44
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
Staff member
Local time
Today, 11:51
Joined
Oct 29, 2018
Messages
21,358
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
Today, 14:51
Joined
Sep 21, 2006
Messages
44
Sub reports. Didn't think about that. That would do it.

Thanks

RJ
 

Micron

AWF VIP
Local time
Today, 14:51
Joined
Oct 20, 2018
Messages
3,476
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
Today, 14:51
Joined
Feb 19, 2002
Messages
42,971
reports have a column option. Sounds like two columns with "over then down" orientation. No code required.
 

Users who are viewing this thread

Top Bottom