Advertisement

04.21.2008 at 03:42AM PDT, ID: 23339045
[x]
Attachment Details

Calculating totals in a Query OR report

Asked by Moncapitaan in Access Reports, Microsoft Access Database, Access Architecture/Design

Tags: , ,

I have a Access report that is a "Customer Account Statement"

The report lists Invoice Number and Dates along with the Amounts for invoices that are still outstanding.

At the bottom of the report I must have a list of totals for invoices thats are:

Current
 1 - 30 days overdue
31 - 60 days overdue
61 - 90 days overdue
Over 90 days

Obviously the system needs to workout (per customer) what is overdue based on todays date.

1st question: - Should I do this in the Query (the datasource for the Report) or should I do it in the report?
2nd question: HOW :)


Thanks

MStart Free Trial
[+][-]04.21.2008 at 04:32AM PDT, ID: 21400502

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 08:14AM PDT, ID: 21402711

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 09:09AM PDT, ID: 21403332

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.22.2008 at 12:27AM PDT, ID: 21408710

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:20AM PDT, ID: 21418770

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:32AM PDT, ID: 21418820

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.28.2008 at 05:39AM PDT, ID: 21453324

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.28.2008 at 06:01AM PDT, ID: 21453485

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.28.2008 at 03:22PM PDT, ID: 21458150

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 01:03AM PDT, ID: 21460334

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Reports, Microsoft Access Database, Access Architecture/Design
Tags: Access Report, Access Query, Calculating Totals in Access
Sign Up Now!
Solution Provided By: OnALearningCurve
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.13.2008 at 06:41AM PDT, ID: 21554919

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906