I'm uisng a crosstab query to give me the top 10 rejects in a query. I want to omit "various", "none" and "unknown"
I can get the criteria to not show "various" by using Not "unknown" but when I try and add none and unknown to the statement they show anyway, I've tried
Not "unknown" Or "none" or "various" and
Not "" with , and ; in between and nothing works.
I tried searching not in this section and there were none with the keyword not, Can I be the only one?
I have a database that is opened by two workstations with full access and four workstations with runtime. The two workstations will full access can open the database at the same time. However, if the database is open by any user, the workstations using runtime will not open.
Does anyone have any idea why this is happening?
hello. i saw this post http://www.access-programmers.co.uk/forums/showthread.php?t=116737
, and i was so happy because i thought it was going to be my same problem, but alas! similar, but different.
i want to know how to do a 'not' query on every value in table's field.
the query should list all of table1's field values that are NOT in table2's field values.
any help would be madly appreciated.
thanks!