Need Urgent Help with query

[Bee]

Hi,

I had a query which used to work perfectly fine, then I changed one of the field names that the query was returning. And then, I rechanged the same field back to what it was and I save it. Later, whenever I run that query, it asks for a parameter with the same field name I changed even though I don't have it anymore.

Any suggestions why this is happening please!!!!

Regards,
B

 

[boblarson]

check to see if you still have it in the GROUPING AND SORTING. That's usually the case when I get those. I forget to remove them and so it can't find the field.

 

[Bee]

check to see if you still have it in the GROUPING AND SORTING. That's usually the case when I get those. I forget to remove them and so it can't find the field.

Hi boblarson,

Is it GROUPING AND SORTING of the query Builder? if so, nothing is in there. Unless there is another one that I don't know about.

Thank you,
B

 

[boblarson]

Sorry, I was thinking about the reports and not the query.

 

[jkl0]

By chance did you change the name in the table itself also.

 

[Bee]

By chance did you change the name in the table itself also.

No, I have not done that.

 

[jkl0]

It may be less trouble to recreate the query, import everything into a new DB or use an SQL statement.

 

[Bee]

It may be less trouble to recreate the query, import everything into a new DB or use an SQL statement.

Thanks for the suggestion. I have actually found where the error was and fixed it. When I changed the field name, Access automatically changed another look up query that was linked to that field and never changed it back. So, I just changed that other query, and it appears to work fine now.

Thank you.
B