Aging Report

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I have a summary query which has 2 fields

[DueDate] [AmountDue]

I am grouping by the due date and summing AmountDue
However I need to create a

0-30 30-60 60-90 >90 day Column with the total amount
due for that period.

Does anyone know how I can do this?

I tried a crosstab query but was unsuccessful. I also
created a seperate query for each time period and used
those as subreports this loads extremely slow and often
locks my computer.

Thanks in advance for any help.
 
Stefan said:
I have a summary query which has 2 fields

[DueDate] [AmountDue]

I am grouping by the due date and summing AmountDue
However I need to create a

0-30 30-60 60-90 >90 day Column with the total amount
due for that period.

Does anyone know how I can do this?

I tried a crosstab query but was unsuccessful. I also
created a seperate query for each time period and used
those as subreports this loads extremely slow and often
locks my computer.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

2 ways I can think of:

1. Use the Partition() function on the DueDate in the query.
2. Use the report's Group by/Sort by to create an expression that
breaks the DueDate into 30-day periods and an >90 period.

BTW, the grouping should be like this: 0-30, 31-60, 61-90, >90. Your
grouping would cause an overlap.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQceQRIechKqOuFEgEQJIwwCgr4hh8s0MR97BwkLUDZ7fPNqD+wMAn1wS
x/KaI226pxCxtnnBau+XlOtg
=v57r
-----END PGP SIGNATURE-----
 
Back
Top