One database and multiple requested totals

G

Guest

I have one database of people and 4 types of dates. I am trying to get a
total for all records for the person, and if one date field is between x and
y, give that count. and if another field is between a and b, give this
count....

looking for one report that says : Total records : xx, Item A between date1
and date 2 = xx, and so on... suggestions?

Thank you in advance
 
G

Guest

My suggestion is to provide some table and field names, data types, sample
records, and desired display in the report.
 
G

Guest

okay...

The database has the following:

Account manager, customer, cust num, follow-up date, appened date, note
created date.

What I am looking for is :

Count of of customers for each Acct mgr, how many accts that have a follwoup
date between x and y (Select query) and append date between different x and
y (Select query), and a count of notes created between a different x and y.
and a list of customers that do not meet the above grouping.
 
G

Guest

Please try again after re-reading my reply. There might be others who will
reply based on your answer but I expect a certain amount of effort on your
part. If you have any questions regarding my request, feel free to ask.

A "database" has tables, queries, forms, reports, code,... Tables have
fields and records. Fields have data types.
 

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

Top