View Full Version : Multiple Criteria


Andy W
04-10-2002, 05:52 PM
I have a database listing plant criteria. I want to create a form that allows a record or records to be selected using multiple criteria. For example, list all plant that are a certain height, that are evergreen shrubs and like a sunny position. IE: The criteria (fields) in question are, height; plant type; position.
I guess it is a filtering type operation??!!
Any ideas?

Jack Cowley
04-10-2002, 06:43 PM
The article below should answer your question for you...

http://support.microsoft.com/support/kb/articles/Q210/2/42.ASP?LN=EN-US&SD=gn&FR=0&qry=QBF&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Andy W
04-11-2002, 05:35 PM
Thanks Jack - I modified it to suit and it works a treat!