I have an Access Table in which there are three columns. First one is the Current Table, DollarAmount and the Number. I have an Update statement which will add 1000 dollars to the DollarAmount and 50 to the Number everyday based on the current Date. This is my statement.<BR>Dim MyDate<BR>MyDate=Date()<BR>Update SystemTable SET SystemTable.DollarAmount = '"&DollarAmount &"' + 1000, SystemTable.Number='"&Number&"'+50 where CurrentDate=MyDate"<BR><BR>But it gives me an error saying "Too Few Parameters". I initially filled out one row with some arbitary values(Say $5000.00 and number=500) and i want it to be incremented by 1000 and 50 respectively based on the date. It is not happening....<BR><BR>Please let me know where i amgoing wrong.