Aged Customer balances

Q

q

I am trying to write a query that presents customer aged balances into 4
predefined columns: Current, 30, 60, 90

There must be a common approach to this using a listbox format. Has someone
got a working example please?

Thanks
 
M

Michel Walsh

You can maybe use a Crosstab and the predefined function PARTITION (see the
help file about that name for the example).

Hoping it may help,
Vanderghast, Access MVP
 
Top