Aged Trial Balance Report

[hjb1974]

I am new to access programing. I am trying to create a report that
will give me both a sum and a count of A/R accounts based on status
codes (i.e. ACT, ADJ,etc.) and date time frame 0-30 days, 31-60 days,
etc. I want to create a parameter box where you would input the
current date and it would calculate and input the rest based on the
time frames. Can someone help me please?

 

[Arvin Meyer [MVP]]

Look up the Partition () function in the VBA help files. You will first need
to run a query using the DateDiff() function in a query to get the number of
days the account has aged. Then using the Partition function, you can build
a second query and report that groups the number of days aged.