Tech Support Guy banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
347 Posts
Discussion Starter · #1 ·
I have a query, I have a couple fields in this query that I am having a problem with. when I run this query I have a field to insert a vender code so that it only brings up those venders. then I have a check box that when you check it puts a date in another field automatically, (a date ordered check box) when I run this query I would like the query to ask for the vender ( I have that done and it works fine) but I would also like it to bring up only the fields for that vender that do not have a check in the date order check box.

Thanks,
Chad
 

·
Registered
Joined
·
11,755 Posts
ok, so in the criteria in the field for the date, put:

=0
or
=Y

The checkbox is weird. I forget if it uses Y/N or if it is something like 0 (for yes) and -1 (for no)...something like that. :)
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top