Aged Trial Balance Report

  • Thread starter Thread starter hjb1974
  • Start date Start date
H

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Account Receivable Aging Report 1
Trial Balance Report 1
Report Help - Starting/Ending Balance 7
Calculating an inventory balance at a "point in time" 5
Aging Receivables Not working 16
Access Opening Balance Expression 25
Summary Report 2
Calculate beginning balance, but print details on report 3

Back
Top