Days Outstanding in a Query

  • Thread starter Thread starter smh
  • Start date Start date
S

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
 
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
 

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

Auto-populate a 'Days outstanding' field 2
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Access Default Microsoft Access Order Entry database issue 0
Calculating an Average 11
Many to many relationships 2
Apply Pament to invoices in form 0
Creating a customer accounts statement vis query? 3
Database design many to many relationships 4

Back
Top