Query-Multiple Rows

[Guest]

Does anyone know how to query a column for more than one type of criteria?

For example if I had the days of the week in one column and changing angle
of the sun in the other, and I want to allow a user to type in any three
days of the week to get the angles for those days.

 

[Guest]

Use this for criteria --
[Enter first date] or like [Enter 2nd date] &"*" or [Enter 3rd date] & "*"

If the user just presses the ENTER key on the 2nd and 3rd prompt it will
pull data for the first date only.