Printing filtered report

[Jrw76]

Ok, Here is my structure
tblCategory:
ID,
Category

tblCompartments:
Compartment No, Compartment Name, Deck
Level

tblLabel Sizes:
ID, Name, Size,
Desc

tblLabelTeam:
EmployeeID, Name

tblLabelPlateData:
ID,
Mel_NO, Plate_NO, RefDwgNo, Category, Valve No,
BLN, HSC_NO, Compartment No,
Deck, Frame, C/L_Ref,
CCL, ACAD_FILE_NAME, Equipment, Remarks,
INSCR_NBR,
Inscription Line 1, Inscription Line 2, Inscription Line 3,
Inscription Line 4,
Inscription Line 5, Inscription Line 6, Inscription Line
7, Inscription Line 8,
Inscription Line 9, Hull, Authority, Letter Size,
Label Size, Process, Material,
Size Code, System, Secure To, Closure Class,
Ordered by, Ordered Date,
Recieved by, Recieved Date, Installed by, Installed
Date, Req No.

10 queries that represent 10 different Label Size(s) that
return
from tblLabelPlateData- Inscription Line 1, Inscription Line 2,
Inscription Line 3, Inscription Line 4,
Inscription Line 5, Inscription Line
6, Inscription Line 7, Inscription Line 8,
Inscription Line 9, Plate No,
Mel_No, RefDwgNo, Compartment, Label Size, ID.
The name of these queries are
the size, for example 2x2.
(NOTE: the criteria here is where label size


equals 2x2 in the Label Size field)

10 Reports that are created from the
ten queries In 2x2 report, for example,
I grabbed the information from query
2x2 and stuck it in a rectangle control sized to 2" x 2".
Now, this will
print only the labels that were entered into tblLabelPlateData where Label Size
Field = 2x2.

The user also wishes to print the reports strictly by compartment. How do I query, filter, to only select the different reports, only in specified compartment.

I have a 1 to many relationship from tblCompartments (field
Compartment No) to tblLablePLateData(field Compartment)

Can we start from
there?

[orange]

You've told us about your tables, but what is the business? Can you describe what this all means in 4 -5 lines?
We only know what you tell us and we have no idea what these represent nor how they fit together.
Do you have a data model/relationships jpg that you could attach?

[Jrw76]

Sure, I'll try...

The idea is to print different size labels with inscriptions on them. The labels are printed as reports- presized by me. The Information is entered into a table called LabelPlateData. That table is queried 10 times. The queries listed return the value in label size which point to the different labels/reports. So, I have a query called 2x2, for example with all the information that will be queried with label size equalling 2x2 as the criteria. That information is printed inside a rectangle sized 2" by 2" located on a report called 2x2. 10 queries, 10 reports. I can print the reports for each specified label size, ie 2x2 or 3x2.25 and so on. The user also needs the option to print these labels by Compartment. So, for example, compartment 1a may have some 2x2 labels, 3x2.25 labels, and so on, but no way to print JUST by compartment....I hope this helps...thanks for your help.

[Jrw76]

Sure, I'll try...

The idea is to print different size labels with inscriptions on them. The labels are printed as reports- presized by me. The Information is entered into a table called LabelPlateData. That table is queried 10 times. The queries listed return the value in label size which point to the different labels/reports. So, I have a query called 2x2, for example with all the information that will be queried with label size equalling 2x2 as the criteria. That information is printed inside a rectangle sized 2" by 2" located on a report called 2x2. 10 queries, 10 reports. I can print the reports for each specified label size, ie 2x2 or 3x2.25 and so on. The user also needs the option to print these labels by Compartment. So, for example, compartment 1a may have some 2x2 labels, 3x2.25 labels, and so on, but no way to print JUST by compartment....I hope this helps...thanks for your help.

[Jrw76]

Is anyone available?

[orange]

So you print labels. You have 10 predetermined label sizes.
What is a compartment?
Who determines the text/inscription?

[Jrw76]

So you print labels. You have 10 predetermined label sizes.
What is a compartment?
Who determines the text/inscription?

Compartment is where these labels will be distributed to by the installer. It is part of a ship.

The the inscription is determined by what was entered into the tblLabelPlateData table from a form.

[Jrw76]

Just figured it out. Had to make a 'make table' paramater query, then query THAT table...make a macro, that opens make table parameter query and the reports from the queries that query that table...if that makes sense.