PC Review


Reply
Thread Tools Rate Thread

Building Columns in a Report

 
 
PeterM
Guest
Posts: n/a
 
      16th Jan 2008
I'm using AC2003. I have a database containing inventory numbers. Is there
a way to generate a report with 3 or 4 columns on one page of those inventory
numbers?

for example

123 456 789 012
345 678 901 234
567 890 123 456
789 012 345 678

Any help is appreciated!
 
Reply With Quote
 
 
 
 
Jeanette Cunningham
Guest
Posts: n/a
 
      16th Jan 2008
Peter,
there is a way in the page set up part of formatting a report - to have
several columns. It is quite a while since I have needed to do something
like this, so I can't be any more specific than that.

Jeanette Cunningham


"PeterM" <(E-Mail Removed)> wrote in message
news:6B9F5BDB-CEC1-499C-B69B-(E-Mail Removed)...
> I'm using AC2003. I have a database containing inventory numbers. Is
> there
> a way to generate a report with 3 or 4 columns on one page of those
> inventory
> numbers?
>
> for example
>
> 123 456 789 012
> 345 678 901 234
> 567 890 123 456
> 789 012 345 678
>
> Any help is appreciated!



 
Reply With Quote
 
John W. Vinson
Guest
Posts: n/a
 
      16th Jan 2008
On Tue, 15 Jan 2008 20:51:00 -0800, PeterM <(E-Mail Removed)>
wrote:

>I'm using AC2003. I have a database containing inventory numbers. Is there
>a way to generate a report with 3 or 4 columns on one page of those inventory
>numbers?


Sure, though it's a bit obscure how you do it!

Design it with a report width small enough to fit one column (2" wide say).
Then use File... Page Setup and select Columns to specify the desired number
of columns to print.

John W. Vinson [MVP]
 
Reply With Quote
 
tedmi
Guest
Posts: n/a
 
      16th Jan 2008
The number of columns applies only to the detail section of the report -
headers and footers span the page. Best bet is to make the detail section the
width of the column, and on the column dialog specify column width as "same
as detail." You also get to specify whether the columns should be filled down
then across or across then down.
--
TedMi

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building a Report LeahT Microsoft Access 3 6th Jan 2009 06:06 AM
Building Columns in a Report PeterM Microsoft Access Reports 1 16th Jan 2008 03:52 PM
Dynamically Building Datagrid Columns Craig G Microsoft ASP .NET 0 22nd Feb 2005 07:39 PM
Dynamically building and swapping out of columns, how? =?Utf-8?B?SmF5?= Microsoft Access Reports 1 10th Nov 2004 05:35 PM
Building a report Jame Microsoft Access Reports 3 30th Jan 2004 07:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:46 AM.