Parameters/expressions in queries

[swift]

Hello again,

I have a query which has a parameter called [Enter Date as DD/MM/YYYY].
This filters out records from my table which match those entered by the user.
However, when the query is run, Access is asking the user to enter the criteria twice. The first time it is labelled Expr1, the second time it is Enter Date as DD/MM/YYYY. There is obviously something wrong in my query, can anybody point me in the right direction here?

Thanks in advance

swifty

 

[DrSnuggles]

Do you have it in the Criteria as well as in the list of Query Parameters??

Also Expr1 normally means you've altered a field name somewhere and MS Access (by default) will name is Expr1. Thus check your field references in your query(ies).

 

[jdraw]

Hello again,

I have a query which has a parameter called [Enter Date as DD/MM/YYYY].
This filters out records from my table which match those entered by the user.
However, when the query is run, Access is asking the user to enter the criteria twice. The first time it is labelled Expr1, the second time it is Enter Date as DD/MM/YYYY. There is obviously something wrong in my query, can anybody point me in the right direction here?

Thanks in advance

swifty

Please show us your query.
I've tried your [Enter Date as DD/MM/YYYY] and it did not ask twice.

Is it possible that you have the same criteria on 2 separate fields?

 

[gemma-the-husky]

or in 2 queries, which are then joined together to make a single query ...

 

[swift]

jdraw

Please show us your query.
I've tried your [Enter Date as DD/MM/YYYY] and it did not ask twice.

Is it possible that you have the same criteria on 2 separate fields?

Ok, I've reviewed and basically rebuilt the query from scratch and it works fine now. I had two fields in the query, asking for the same parameter.
I guess I should probably go back to my books before shouting for help!! Thanks to all those who replied

swifty