Help with a Report

J

JackieGerman

Hello,

I have to create a database for my boss in which he wants to show all the
jobnumbers for each production section. as there can be up to 400 jobcards in
this report, it would be very long. The only field within the details section
is the field with the jobnumbers from each record. Is it possible to show a
few of these fields (from various records) left to right instead only top to
bottom?

I hope my question is clear enough....
 
R

rico

I'm not sure what your talking about as i dont know anything about your
company. Try to explain questions in terms of field table and form names. The
best i can make out is that your talking about doing a query. Open a new
query in design view, select the fields you want to show then set criteria
that returns the records you want to see.

HTH
Rico
 
W

Wayne Morgan

Yes, set up the report as a multicolumn report and tell it to print "across
then down". For examples, look at the Northwind database (sample database
that comes with Access). There are a couple of reports that use columns,
"Customer Labels" and "Products by Category". The column setup is in the
report's page setup (File|Page Setup).
 
J

JackieGerman

Hey Wayne,

this helps alot, but is it poosible to change the sorting headers so that
they will not be moved across in the columns? I really just want to apply
this to the "Detail" Section of my report.
 
W

Wayne Morgan

What are you using for sorting headers? Group headers will print at the
start of each group, even if that is in the middle of a column. On the
Format tab of the Group Header's Properties sheet you will find two options
that may help, "Force New Page" and "New Row Or Col". These will allow you
to start each section on a new page or new row or column.
 
J

JackieGerman

Thanks alot - this really solved my problems!

Wayne Morgan said:
What are you using for sorting headers? Group headers will print at the
start of each group, even if that is in the middle of a column. On the
Format tab of the Group Header's Properties sheet you will find two options
that may help, "Force New Page" and "New Row Or Col". These will allow you
to start each section on a new page or new row or column.
Click to expand...
 
Top