Tables

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
Frank said:
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?
Click to expand...

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.
 
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
 
Back
Top