Calculate days in access

[Tim Lewis]

Hello,

I have a table in access 2000 that we enter a start date and an end date. I
would like to know if it is possible to calculate the number of days from
start to finish. Any help would be great.

Thank you,

Tim

 

[Bob I]

And subtracting the start date cell from the finish date cell doesn't do
what you want?

 

[Tim Lewis]

Would I do this in a query, or in the table?

Thanks

 

[Bob I]

An update query could be used to place the number of days in a field in
the table, or if a report was created then it would show in the report.
Subtracting one date from another and showing the result as an integer
will give the number of days.