Windows XP using OR in a parameter query

A

aaldridge

Joined
Jun 17, 2005
Messages
9
Reaction score
0
I want to create a parameter query that asks for a date and then returns all records where [Status]="Active" and where either [ReviewDate] OR [ReviewExtensionDate] are equal to the date entered. I got the OR statement to work correctly, however, the problem that I'm having is that when I run my query, I get asked for the date twice, instead of just once. So, my question is, how do I pass the same parameter to two different fields without having to enter the parameter twice? Any help I can get on this would be greatly appreciated.

Amanda
 
Never mind! I figured out that if I created a custom form, I could pass the parameter to both fields without entering twice. Thanks anyway though!

Amanda
 
Back
Top