var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access Query Design
In a query, how can I add multiple criteria?
Basically, I have a users table with the Field 'Category' I am trying to produce a report that shows me a collection of Categories.
I have 5 Categories, but I need 1 report that combines 2 types of Category.
I want to take to take data from those users in the 'Teacher Governor' Category and also the 'Staff Governor' Category - The string I have been trying to enter at the moment is:
"Teacher Governor" AND "Staff Governor " - I have had no luck....
Any help would be greatly appreciated.
PS. - If I just try a Single Criteria like "Teacher Governor" it works, I can't get the 'And' Syntax...
Try using the IN operator
WHERE field1 IN ('value1', 'value2', ... , 'valueN')
AND is used when it must meet all criteria.
OR is used when it must meet any of the criteria.
Oops, missed that! D'oh!
WHERE category = "Teacher Governor"
AND category = "Staff Governor
Thanks very much guys, kindly appreciated.
Very sorry to trouble you again, but what is the exact syntax for this?
In the query grid, put Teacher Governor on the first criteria row and Staff Governor on the next row down. If you have any other criteria, make sure to put it on both lines.