Adding Dates

L

Leo

How can I create a field in a table that adds to date
fields? The 2 date fields are in the same table. I simply
want to add the time between 2 date fields.
 
K

Ken Snell

You don't really want a field to store a calculated value, do you? Just
store the start and end date/time values in their own fields, and then use a
query with a calculated field to calculate the difference. That way, your
data are not "out of synch" if one value changes and you forget to update
the "difference" field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top