View Single Post
  #2 (permalink)  
Old October 9th, 2007, 07:46 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I am not sure if the date is a valid field name.

I would suggest restructuring the table to two tables in order to keep a history of price increases. I wouldn't rely on adding a new field named for the date each time you want to update prices. Is that what you are trying to do?

In any event, there has to be a field named 10/07/07 in the updated table to receive the values from your equation on the update. Are you able to select the target field when making the update query?

mmcdonal
Reply With Quote