It's simple but it aint working

[Paul Purvis]

Ok, Brain now in close down mode!

I have a Tool testing database, which records when a tool was last tested, a initial screen prompt when starting up tells u what tools need to be tested, some @ 3 monthly intervals some at 6monthly and most at 12monthly.

I need to print out what tools are due to be tested tried this

[LastTestDate]<=DateAdd("m",-3,"Date") «Expr» [ToolId & "Needs Testing"]

But wrong syntax (or brain fatigue more like!!! )

 

[namliam]

[LastTestDate]<=DateAdd("m",-3,Date())

Will do the trick...

How ever, accoording to you explanation you need to be able to make the -3 variable, but i am hoping you can figure that one out on your own. With your closed brain and all...

Regards