One database and multiple requested totals

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
My suggestion is to provide some table and field names, data types, sample
records, and desired display in the report.
 
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.
 
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.
 
Back
Top