Tables

[Frank]

How do I set up a "datediff" in a table. I need to record
the days between date of account and date received. Ihave
both these dates showing in seperate columns but need to
have the elapsed days in a seperate column?

With Thanks

Frank

 

[Rick Brandt]

How do I set up a "datediff" in a table. I need to record
the days between date of account and date received. Ihave
both these dates showing in seperate columns but need to
have the elapsed days in a seperate column?

You don't. At least not in a table. Calculations do not belong in tables
which is why there are not easy ways to get them there. Create a query
with your DateDiff calculation and then use the query every place you would
ordinarily have used the table.

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Luiz Cláudio]

Hi Frank,

you should create a query with the calculated field (using DateDiff
function) instead of creating it in the table.


Luiz Cláudio C. V. Rocha
São Paulo - Brazil