Query Problem

[TM]

Hi all

I have set up a select in a query between two dates.I have another separate
query between two dates and also by employee number.[Start Date:]and[End
Date:] on date field.
When I add the employee number parameter to the second query the first query
then asks for the employee number,which I do not want..[Start Date:]and[End
Date:] on date field on first query
[Enter Employee Number:]On Employee ID Field On second separate query.
The queries are not linked but are getting the information from the same
tables.
This affects reports I run on either query as they both end up asking for an
Employee Number.............

How can I avoid this situation or am I just stupid?

Thanks

TM

 

[John Spencer (MVP)]

wow, I've never seen this situation before.

If you were using one query as a source in the other query I could understand
this, but you specifically said "...queries are not linked..."

I would try temporarily renaming query two (where you are adding the employee id
parameter) and recreating it from scratch with a different name. Then if you
don't have the problem with query one when you run it, rename the new query to
the name you had for query two and see what happens.

If you still have the problem, I might suspect some minor corruption in the database.

Post back and let us know. Perhaps someone will have an idea (especially if you
can post the SQL for both of your original queries).

 

[Angela M]

I'll try it and let you know. Thanks for taking the time to answer.

TM a Brit in Canada

wow, I've never seen this situation before.

If you were using one query as a source in the other query I could understand
this, but you specifically said "...queries are not linked..."

I would try temporarily renaming query two (where you are adding the employee id
parameter) and recreating it from scratch with a different name. Then if you
don't have the problem with query one when you run it, rename the new query to
the name you had for query two and see what happens.

If you still have the problem, I might suspect some minor corruption in the database.

Post back and let us know. Perhaps someone will have an idea (especially if you
can post the SQL for both of your original queries).

Hi all

I have set up a select in a query between two dates.I have another separate
query between two dates and also by employee number.[Start Date:]and[End
Date:] on date field.
When I add the employee number parameter to the second query the first query
then asks for the employee number,which I do not want..[Start Date:]and[End
Date:] on date field on first query
[Enter Employee Number:]On Employee ID Field On second separate query.
The queries are not linked but are getting the information from the same
tables.
This affects reports I run on either query as they both end up asking for an
Employee Number.............

How can I avoid this situation or am I just stupid?

Thanks

TM