SHOW RECORDS FOR 3 DIFFERENT CRITERIA IN A DATABASE

  • Thread starter Newbie to this!!!
  • Start date
N

Newbie to this!!!

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?
 
D

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.
 
N

Newbie to this!!!

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.
 
J

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.
Click to expand...

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]
 
Top