In the following query, the two parameter prompts ("Type the beginning date:", etc), pop up twice. It returns the correct results, but why come up twice? I don't think the last prompt should come up either, since it's the same as the previous one, but at least I'd understand that. I've tried changing parantheses, etc, same thing. Thanks.
I hate working on other people's old rickety code
Code:
SELECT DISTINCTROW [Full Data].[Record Number], [Full Data].Date, ...
FROM [Full Data]
WHERE fldReported = False 
AND (([Full Data].Date Between [Type the beginning date:] And [Type the ending date:])
OR (fldCompleted = TRUE AND fldTermDate <= [Type the ending date:]));