SHOW RECORDS FOR 3 DIFFERENT CRITERIA IN A DATABASE

[Guest]

I'm currently trying(?) to learn Access, and have hit a snag. I have a
database made up for a furniture production company, and need to show only
the records for 3 fields in a query. I have tried many times,
(unsuccessfully) to do this, so can anyone help?

 

[Duane Hookom]

Maybe you could provide an example of your records, what you want to
display, and why.
"show only the records for 3 fields in a query" doesn't make much sense to
me.

 

[Guest]

Thank you for your prompt reply!! Well, I have a query with ProductionDate,
Shift, DepartmentID, ProductID, and ProductionQty. I need to show the
records only for "Shift 1", the department name "FIN" and just one of their
products. I've tried all ways to do this but can't do it. I have tried
typing 1 in the (shift) criteria field, then "FIN" in the (Department)
criteria field and "Bookcases" in the (product) criteria field.

Does this help you? I hope so.

 

[John Vinson]

Thank you for your prompt reply!! Well, I have a query with ProductionDate,
Shift, DepartmentID, ProductID, and ProductionQty. I need to show the
records only for "Shift 1", the department name "FIN" and just one of their
products. I've tried all ways to do this but can't do it. I have tried
typing 1 in the (shift) criteria field, then "FIN" in the (Department)
criteria field and "Bookcases" in the (product) criteria field.

Are any of these fields Lookup fields? If Shift is a lookup field, for
instance, then you may be *seeing* the text "Shift 1" but the actual
table contents might be a number.

If the field actually contains "Shift 1" then that is the criterion
that you need to use: "Shift 1". The text strings "1" and "Shift 1"
are different text strings, and will not match.

John W. Vinson[MVP]

 

[Guest]

Thank you John, Yes it worked a treat. Thank you again.
Judy Johnson