Not sure if this is possible

[Lori]

I have my database set up to process our company's cellphone bills.
Everything works perfectly but there is a feature I would like to add. since
all of the data is already there, I have a query set to look at the data and
provide me with the minutes used for each month, date of the invoice and cost
charged for each phone.
In the report I have it sorted by phone number and user and I have averages
set for each user simply by entering in the start and end dates of the
invoices queried.

Now, here's the question. I know I can do averages in a query but would that
no depend on specifically knowing how many months a particular phone number
has been billed? We are constantly changing and issuing new phones so there
is no way to be sure on a quarterly basis that everyone on the list has had
their phone for three months. Is there a way to have a query count the
number of times the name or number appears? The report for all #s works
perfectly but I need to be able to summarize this report (94 pages) and be
able to run a report based on the issues arising from this data.

HELP

 

[mscertified]

Look in Access help for the COUNT function

-Dorian

 

[John W. Vinson]

Now, here's the question. I know I can do averages in a query but would that
no depend on specifically knowing how many months a particular phone number
has been billed? We are constantly changing and issuing new phones so there
is no way to be sure on a quarterly basis that everyone on the list has had
their phone for three months. Is there a way to have a query count the
number of times the name or number appears?

Sure; a Totals query grouping by phone number and using the Count totals
operation. Not knowing the structure of your table I'm not sure just what the
query would have, but it's just a variant on doing the sum.

John W. Vinson [MVP]

 

[Lori]

Perfect, Thanks John1
--
Lori A. Pong

Sure; a Totals query grouping by phone number and using the Count totals
operation. Not knowing the structure of your table I'm not sure just what the
query would have, but it's just a variant on doing the sum.

John W. Vinson [MVP]