criteria code to select single row from a table in a query

BWG3

Registered User.
Local time
Today, 02:19
Joined
Sep 22, 2009
Messages
44
I hope this has a simple fix. I'm making a query and I have selected a table that has 3 rows. ex (1 - Right, 2- Left, 3-Neutral). Is there a criteria code that will only select the neutral ones when I print out a report from this query? The table is not a junction table, so I can't just put the number 3 in the criteria column. When I try to put a 3 in the criteria column, ms access puts "3" in the column and it does not work when I try to print out the report. Any suggestions? Thanks in advance.
 
Ahh, yes. Thank you. That's exactly what I needed.
 

Users who are viewing this thread

Back
Top Bottom