Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-28-2019, 11:41 AM   #1
RJW
Newly Registered User
 
Join Date: Sep 2006
Posts: 38
Thanks: 9
Thanked 0 Times in 0 Posts
RJW is on a distinguished road
Two Columns, one for even one for odd

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

RJW is offline   Reply With Quote
Old 10-28-2019, 11:44 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,656
Thanks: 58
Thanked 1,463 Times in 1,444 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Two Columns, one for even one for odd

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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
RJW (10-28-2019)
Old 10-28-2019, 11:47 AM   #3
RJW
Newly Registered User
 
Join Date: Sep 2006
Posts: 38
Thanks: 9
Thanked 0 Times in 0 Posts
RJW is on a distinguished road
Re: Two Columns, one for even one for odd

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

Thanks

RJ

RJW is offline   Reply With Quote
Old 10-28-2019, 11:48 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,656
Thanks: 58
Thanked 1,463 Times in 1,444 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Two Columns, one for even one for odd

Quote:
Originally Posted by RJW View Post
Sub reports. Didn't think about that. That would do it.

Thanks

RJ
Hi RJ. You're welcome. Happy to assist. Good luck!
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 10-28-2019, 04:07 PM   #5
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,253
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Two Columns, one for even one for odd

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
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 11-02-2019, 10:58 PM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,316
Thanks: 15
Thanked 1,601 Times in 1,520 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Two Columns, one for even one for odd

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

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Tags
columns

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
table columns in record set ,how to view them in subform of a form in columns? hfs Modules & VBA 1 08-22-2013 12:19 PM
Transposing columns to rows with variable columns using VBA? sgundlac Modules & VBA 2 08-12-2013 12:35 PM
Returning the sum of several columns when other columns in the row hold matching data EmmaP Queries 4 11-15-2009 04:29 AM
Selecting all columns after a specific number of columns from a cross tab query accessaspire219 Queries 3 07-20-2009 01:49 PM
Totalling Columns & Rows into Columns Nate74 Queries 3 04-23-2007 04:19 AM




All times are GMT -8. The time now is 03:10 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World