Need query for # of days delinquent and amount due

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to find out how to set up a query/report to tell me how many days
deliquent a client is in paying their account, ie. 0-30 days, 31-60 days,
61-90 days etc... AND how much is due
 
Hi,


You can try a crosstab with PARTITION (see the help file under that
word).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top