Cached Update Queries

[123James]

I have created 6 update queries that take data from 6 different tables (created using crosstab queries) and place it into a single table. I ran each query after i had created it. The first worked fine. However, the next five simply updated the specified fields with the same data from the first update query!

The only explanation i could think of for this was that maybe the data was being cached as a result of the way i created the queries. I created each update query by editing and renaming the previous one. Was this a big mistake?!

 

[KeithG]

no, you should be fine. Can you post your SQL statements?

 

[123James]

Fixed It

Thanks for the offer of help Keith but i have managed to sort the problem. I created the query using QBE and when i changed the table name to draw data from the crosstab table i simply clicked into its properties and renamed it, which doesn't actually work! all i did to fix the problem was delete and add the table again!