Aged Customer balances

[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

 

[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