Create an Expression

[jazzyq]

Using Access 2003, I want to calculate the number of days late for reports by
adding the "Last Act" (Date) to the current date.

 

[What format to use?]

Could you add an unrefrenced text box type this into the box =Date()-[Last
Act] or =[Last Act]-Date() not sure which way it goes. Try it.

 

[WendyWest]

Can you use the DateDiff function? =DateDiff("d", [Last Act], now())

 

[SusanV]

Hi,

You can use the DateDiff function for this:
http://www.fabalou.com/Access/Modules/datediff.asp