Use of Datediff

[joee]

Please can someone assist me in this ?
I need to find the difference between 2 dates.(Planned & Realized)
It has to be Realized minus Planned.
I would like a querie to write the difference in days when I open it.
Attached is a sample database with a table and a Querie.
Highly appreciate if someone could show me how to incooporate above in attached database.
In ad vance thanks.

 

[boblarson]

Get rid of Difference in the table and in the query change it to:

Difference: DateDiff("d",[Realized date],[Planned date])

 

[joee]

Thanks for your reply.
Sorry I do not get what you mean.
Please can you show me in attached sample of my database. See former thread.
Appreciate very much.
Thanks

 

[vbaInet]

Thanks for your reply.
Sorry I do not get what you mean.
Please can you show me in attached sample of my database. See former thread.
Appreciate very much.
Thanks

boblarson means, open your query in design view, and on the field you wrote "Difference", paste his line of code there. i have attached it.

 

[joee]

Thanks , to both of you . It works fine.