Calculation in query not updating

[Salbrox]

Hi folks,

I have a strange issue with a query based on a linked SQL 2005 table in Access 2010.

The query is quite big and contains a chain of calculations where there are a number of columns which are calculated in a chain from one to another. I am having trouble with the final link in the chain.

The final value does not update if I change any of the input values(e.g. If i change the lead time the result stays the same)

This is the query column in question:

FDD:[SAF]+([Lead Time]*7)

[SAF] comes from a chain of dates which increase in varying inccrements.

e.g. [Date1] : "01/01/1983"
[Date2] : [Date1] + 7
[Date3] : [Date2] + 4
[Date4] : [Date3] + 7
[Date5] : [Date4] + 2
[Date6] : [Date5] + 7
[SAF] : [Date6] + 7
[FDD] : [SAF]+([Lead Time]*7)

Everything works up until [FDD] the dates all update but not the [FDD]. Even if i close teh query and open it again the new Lead Time is still there but the FDD is still showing an incorrect value. :banghead:

Any help is super appreciated!

 

[SOS]

Date1 should be

[Date1]:#01/01/1983#

with # signs instead of quotes.

Also, use the NZ function on LeadTime

[SAF]+Nz([LeadTime],0)

 

[Salbrox]

Date 1 is a value in a field though. I could post the entire query if you like its huge though.

 

[Salbrox]

Tried the NZ() function. Didnt work. I noticed though that if i change the Field Need Date that the FDD changes i really dont understand why the FDD doesnt update when the lead time is changed.

Funny thing is the same query works on another database but not always which is strange. Some records will not have a FDD date and some will have it blank. Only on occassion though. Usually FDD field will always be filled correctly.