Query-Multiple Rows

Q

Quandary

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.
 
K

KARL DEWEY

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.
 
Top