Contractor Talk - Professional Construction and Remodeling Forum banner

1 - 1 of 1 Posts
F

·
Guest
Joined
·
0 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
Top