thanks alot !
Had to chance one small thing (a few []) and it works fine !
heres the final code
Code:
UPDATE Villas INNER JOIN Bookings ON Villas.VillaID = Bookings.VillaID SET Bookings.TotalCost = IIf([Bookings].[BookingStart]>#6/5/2005# And [Bookings].[BookingStart]<#12/12/2005#,[Bookings].[Weeks]*[Villas].[PricePerWeek]*1.2,[Bookings].[Weeks]*[Villas].[PricePerWeek]);
Now thats fixed ... is there a way to have it between the months instead of the months and year, so that it wouldnt need to be changed every year.