Days Outstanding in a Query

[smh]

I am running Access 2000 SP3 on Win 2K machine. I have a database that I
track when I invoice a client and when payment is received, I have a field
in the database and query that is "days_out". I would like access to
calculate the "Days Outstanding" for each invoice based on date of invoice,
[which is a field in database] and today's date.

How can I do that and what would the formula be for the calculation.

Thanks
SMH

 

[Rick B]

In your form or report you would add an unbound field and put the following
in the field...

Date() - [InvoiceDate]



In a query you would add a new column and put something like...

DaysOutstanding: Date() - [InvoiceDate]



You would not, of course, store this in your table since it would change
every day.


Rick B