Query to calculate

[sha1023012]

Ok I am still learning access i am trying to add a calcualte field name DaysToShipp to calculate the number of days taken to fill each order.The expression will include the orderdate and the shipped date; the results will not contain negative numbers. This is the code but it dont look right to me. Below is a picture of it.

[pbaldy]

Check out the DateDiff function.

[sha1023012]

I am trying with the DateDiff but I can not get that one to work either.

[pbaldy]

Not knowing what you've tried or how it failed, I'm stumped.

[sha1023012]

I figure it out.