By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,060 Members | 1,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,060 IT Pros & Developers. It's quick & easy.

Report question: 2 columns of data

P: n/a
Hi all,
Was wondering if someone could answer this report question for me.
What I want to do is print 2 columns on the report, with each column's
data pulling from the same fields. BUT, I want each column to
represent a different record, not the same record. Does that make

For example, say this is my report layout:

Field1 Field1
Field2 Field2
Field3 Field3

I DON'T want the report to look like this:

Tom Tom
123 Main Street 123 Main Street

I want it to process a separate record, like this:

Tom Rich
123 Main Street 456 West Sixth

Is this possible? Thanks in advance for the help!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a

Looks like you could use a method for printing
address labels. See help for specifics on:


In outline, you do this:

In report design view, set up the two columns in
Page Setup on the File menu. Make the detail
section just one column wide - ie, only put the
field controls once in the report design.

Write some code for the report's detail section to
loop through the report's recordset in vba, using the
above three properties (in the loop) to PrintSection,
MoveLayout (move to next column) and change to
the NextRecord.

HTH. Regards
Nov 12 '05 #2

P: n/a
Just realised you don't need to use those
properties or write code for the Print Event of
the detail section if you're not skipping columns
or repeating labels, ie you'll do OK with just the
settings in the Page Setup screen.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.