count records by date range

P

PHisaw

I have a report broken down by quarter grouped by salesperson. I'm trying to
count the number of invoices per salesperson for each quarter. I thought I
could put a text box under each quarter with count or dcount expressions - so
far everything ends in "error" or same wrong total for each salesperson. I've
tried different variations on the following control source for textbox:
DCount("[Inv]","table1","[InvDate]=Between#1/1/07#AND#3/31/07#") along with
several Count expressions.

If someone would supply the correct expression, I would certainly appreciate
it.
Thanks,
Pam
 
P

PHisaw

Thanks for the reply - but I'm not sure if I fully explained what I'm trying
to accomplish. I need a count of invoices and it's in the group footer not
page footer. I don't need running sums - just a count of invoices per person
for each quarter.
Thanks again,
Pam

Michael said:
Try modifying the resolution from this site
http://support.microsoft.com/kb/296249/en-us

Because I'm guessing you are putting that text box in the page footer where
it seems to have problems running sums without code.

I have not had complete success yet with the solution frmo that site but I'm
getting closer than I was when I was in the same situation you are in right
now.

PHisaw said:
I have a report broken down by quarter grouped by salesperson. I'm trying
to
count the number of invoices per salesperson for each quarter. I thought I
could put a text box under each quarter with count or dcount expressions -
so
far everything ends in "error" or same wrong total for each salesperson.
I've
tried different variations on the following control source for textbox:
DCount("[Inv]","table1","[InvDate]=Between#1/1/07#AND#3/31/07#") along
with
several Count expressions.

If someone would supply the correct expression, I would certainly
appreciate
it.
Thanks,
Pam
 
M

Michael

Try modifying the resolution from this site
http://support.microsoft.com/kb/296249/en-us

Because I'm guessing you are putting that text box in the page footer where
it seems to have problems running sums without code.

I have not had complete success yet with the solution frmo that site but I'm
getting closer than I was when I was in the same situation you are in right
now.
 

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