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.