more than one criteria-help this is super urgent

[helpmeplease]

Can I have more than one criteria filled out in design view to give me specifics?

 

[jwindon]

What type of specifics?

You can assume that when you put any criteria in the row of Criteria: that the query will select where Criteria is met.

For example to select the names of all employees who were "terminated" and who were hired after October 1 from the tblEmployeeInfo

the query is:
fieldname [EmpStatus]
criteria: ="terminated"

fieldname [HireDate]
criteria: >10/1/01

The query reads: Find all employees where [EmpStatus] equals "Terminated" AND [HireDate] is greater than October 1, 2001.

If you want to find either?

Put the OR part of the specifics in the OR row.

HTH


field:

 

[tbaxter]

Are you looking to return specific records based on "and" criteria or "or" criteria?

I'll try to help by giving an example, though. Let's say you sell greeting cards and you were looking to return all orders inputted after a certain date and associated with a specific town (or state). If you wanted all orders inputted for people in Georgia after Oct 1, 2001, you'd put "GA" (assuming you use the accepted state abbreviations in your database) in the criteria block of the State field and ">#10/1/2001#" (less quotes) in the criteria block of the date field. These would be on the same "line." If you wanted all records in Georgia OR all records after 10/1/2001, you'd put "GA" in the criteria for the State field and ">#10/1/2001#" in the "or:" criteria of the date field.

I hope that makes sense and helps answer your question!