Contractor Talk - Professional Construction and Remodeling Forum banner
1 - 1 of 1 Posts

Discussion Starter · #1 ·
Hi I seem to be having trouble with MIcrosoft Access i can't seem to get updates statements working. Right now i have copied the data from the average of purchase category from the Make table query and pasted it to AVPCAT field in the Customer dimension table. I am now using the update query to replace the numbers in the AVPCAT field with the text best middle worst. I have three seperate update queries one for each best middle and worst. In the update field i have the word "best" and in the the criteria field i have >"79.99". The results work for some of the records but not all of them. The syntax is basically the same for others but the results i am getting are very different. Any suggestions.
1 - 1 of 1 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.