I want to extract only the records that meet certain criteria. I have a field "Priority" that has a look up for
1 Mission Critical
2 Mission Impact
and 3 others.
How do I write my query to extrapolate only one of these criteria.?
Type "Mission Impact" or Mission Critical" or "..." etc,in the criteria section under the field which contains the data that you wnt to select from.
This is a sample SQL statement for a query finding a value of priority =1 with a table name of Table3:
SELECT Table3.priority FROM Table3 WHERE (((Table3.priority)=1));
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.