Count Check Marks

L

lmossolle

I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
=Sum(Abs([ADC_DD-2656-7]))
when printing the report I get multiple pages. Could someone assist? If I
can format the report to show the Month and year and the totals, that would
be Great!
 
S

Stefan Hoffmann

hi,
I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
=Sum(Abs([ADC_DD-2656-7]))
Click to expand...
Why don't you count it in the record source (the query behind your report)?
when printing the report I get multiple pages.
Click to expand...
Where is the relation to the way of counting your marks? Sorry, I don't
see it.


mfG
--> stefan <--
 
L

lmossolle

Could you please explain?



Stefan Hoffmann said:
hi,
I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
=Sum(Abs([ADC_DD-2656-7]))
Click to expand...
Why don't you count it in the record source (the query behind your report)?
when printing the report I get multiple pages.
Click to expand...
Where is the relation to the way of counting your marks? Sorry, I don't
see it.


mfG
--> stefan <--
Click to expand...
 
L

lmossolle

SQL View

SELECT NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date
FROM NEWRSO
GROUP BY NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date, Year([Date])*12+Month([Date])-1
HAVING (((NEWRSO.Date) Between #1/1/2007# And #12/31/2007#))
ORDER BY NEWRSO.Date, Year([Date])*12+Month([Date])-1 DESC;
 
D

Duane Hookom

You have given us only one field name which apparently is a yes/no data type.
We don't know anything about how your record source is filtered or what your
date fields are or how you really want your report to display.
 
L

lmossolle

SQL View
SQL View

SELECT NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date
FROM NEWRSO
GROUP BY NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date, Year([Date])*12+Month([Date])-1
HAVING (((NEWRSO.Date) Between #1/1/2007# And #12/31/2007#))
ORDER BY NEWRSO.Date, Year([Date])*12+Month([Date])-1 DESC;

I am printing multiple pages in stead of one.

Duane Hookom said:
You have given us only one field name which apparently is a yes/no data type.
We don't know anything about how your record source is filtered or what your
date fields are or how you really want your report to display.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


lmossolle said:
I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
=Sum(Abs([ADC_DD-2656-7]))
when printing the report I get multiple pages. Could someone assist? If I
can format the report to show the Month and year and the totals, that would
be Great!
Click to expand...
Click to expand...
 
D

Duane Hookom

Either hide details in your report or in your query if you only want to
display aggregated values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


lmossolle said:
SQL View
SQL View

SELECT NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date
FROM NEWRSO
GROUP BY NEWRSO.[ADC_DD-2656-7], NEWRSO.[ADC_DD-2790], NEWRSO.[ADC_SF-1174],
NEWRSO.[ADC_SF-1199A], NEWRSO.ADC_W4P, NEWRSO.ADC_ChangeofAddress,
NEWRSO.ADC_SpouseElectionStatement, NEWRSO.ADC_EstimatedAnnuityWorksheet,
NEWRSO.Date, Year([Date])*12+Month([Date])-1
HAVING (((NEWRSO.Date) Between #1/1/2007# And #12/31/2007#))
ORDER BY NEWRSO.Date, Year([Date])*12+Month([Date])-1 DESC;

I am printing multiple pages in stead of one.

Duane Hookom said:
You have given us only one field name which apparently is a yes/no data type.
We don't know anything about how your record source is filtered or what your
date fields are or how you really want your report to display.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


lmossolle said:
I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
=Sum(Abs([ADC_DD-2656-7]))
when printing the report I get multiple pages. Could someone assist? If I
can format the report to show the Month and year and the totals, that would
be Great!
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

multiple pages 2
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
SUM of COUNT? 8
Reports for Yes/No Variables - Help! 3
Sum Check Box 5
Date Wildcard 2
Summary Report 2
Count 3

Top