View Full Version : Duplicate Queries


skwilliams
02-08-2002, 10:11 AM
I have two queries that are identical except one has a criteria of Monday and the other Tuesday. The table they are pulling from has two records with identical fields. One record has a field with Monday in it. The other is Tuesday. When I run each query the Monday Query displays fine. The Tuesday query doesn't show any records, just the headings. Both records contain the proper information in all fields and no null values.

Does anyone have any suggestions what the problem might be?

Thanks.

RV
02-10-2002, 11:42 PM
>When I run each query the Monday Query displays fine.<

So the reason why it's not collecting "Tuesday" is in the statement(s) of your query (queries).
Post both statements, I'll have a look at it.

RV