Update Query

[Siobhan]

Please can any of you help me?



My database is for a local garage and I have a booking table.
My booking table has the following fields;
Booking ID
Customer ID
Service Items ID
Booking Date - Long date format
Booking Time
Booking Duration
Total Booking Cost
Payment Due By

I am trying to create an update query which will update the "Payment Due By" from adding 7 days to the "Booking Date" however, when I try to update by doing [Booking Date] +7 nothing happens?

Please can you help me to complete this update query

This is the SQL that I have tried to use but with no luck.... UPDATE tblBooking SET tblBooking.[Payment Due By] = [tblBooking]![Booking Date]=DateAdd("d",7,[tblBooking]![Booking Date]);

[pbaldy]

Please don't post the same question twice:

https://www.accessforums.net/queries...ded-13001.html