Hello again,

I need help sorting by InvoiceDate for the AgedReceivable form.

I have placed 4 text fields in the footer of the form "subfrmStatements". The control source for each text field begins =IIf(IsNull([InvoiceBalance]),0,Sum([InvoiceBalance])).

The sub form shows only the records related to a specific customer that is selected on the main form. I would like to sort the InvoiceBalance by the InvoiceDate field with the following parameters:

0 – 30 days
31 – 60 days
61 – 90 days
over 91 days


Thanks in advance for all help!


D. Bartelt

__________________
D. Bartelt

Do a help search in VBA for DateDiff


mmcdonal