large table problem

B

babuga

here is my situation. i have a large table i brought over from excel, 9kish
rows. i do inventory. All items have a tag#, location, department, room,
name, model, sn, price, etc. i am trying to make a report by department(by
the way, there are 53) and room #, and then sorted by tag #. i tried to
just pull everything over to reports, but its one big massive report, that
really doesnt help me. i need to be able to make 53 different reports. by
dept. is there any way to make a report, using just the items with dept 1,
then dept 2, etc. i tried to copy the master table and put a filter
on it, which it did give me just the one dept, but when i went to make the
report, it made the whole 9k. not just the 200 in that one dept.
 
V

Van T. Dinh

Create a Query with criteria to select only the Dept you want and use this
as the RecordSource for your Report.

Alternatively, you can create one big Report using all Records / rows in
your Table but use the Sorting & Grouping feature of the Report to group and
sort Records as required. You can create group headings, e.g. a group
heading for each Dept.

Check Access Help on "Sorting ang Groupings" for Reports.
 
B

babuga

van thank you, never delt with quereies before, that did it. one last
question. on the report side, i make a report of the query, but i have
to get in design to clean up the look of the report, wich i dont mind. but
53 times will get old. how can i duplicate the look of the report using the
wizard, (as in layout align left 2, but after it makes it, i have to move
some of the boxes and widen etc)
 
V

Van T. Dinh

You need only ONE Report (not 53) and base your Report on a Parameter Query
which will ask you which Dept you want.

Check Access Help on Parameter Query.

You should read an introductory Access book which cover most of these basic
manipulations in Access.
 
B

babuga

thank you thank you thank you. i am an excel person, and not an access
one. you just saved me . bows courteously.
 
A

Al Camp

You'll need to use the Sorting and Grouping of the report to "break" your
data via Department and RoomNo and also sort on TagNo.
If you need each Department to be printed "seperately", then place a
PageBreak in the Department footer.
Department 1 will report on page 1, Department 2 on page 2, etc...
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
V

Van T. Dinh

You're welcome ...

I am an Access person but I read Excel books also. hence, you can also read
Access books. <smile>
 
Top