Can I set up calculated field in a table using dates?

A

ACCESSCRAZY

I need a field that'll calculate the days interval between two date fields in
the same table. I know I can get this through a query or form, but I prefer
to use the table as the source of this info, if at all possible. Thanks for
any input you may have. Using Access 2000.
 
F

fredg

I need a field that'll calculate the days interval between two date fields in
the same table. I know I can get this through a query or form, but I prefer
to use the table as the source of this info, if at all possible. Thanks for
any input you may have. Using Access 2000.
Click to expand...

Not only is this not possible in a table, it's unwise.

As long as you already have the two dates stored, use a query or form
to do the calculation.
 

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

Similar Threads

ASK Field Formatting 1
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
QBF & Query Malfunction 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Using Lookup Query with Calculated Value in Table ComboBox 2
Page numbering with Merged Document and IF statements 1
calculate dates between 2 fields in a table 1

Top