Count Check Marks

[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!

 

[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]))

Why don't you count it in the record source (the query behind your report)?

when printing the report I get multiple pages.

Where is the relation to the way of counting your marks? Sorry, I don't
see it.


mfG
--> stefan <--

 

[lmossolle]

Could you please explain?

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]))

Why don't you count it in the record source (the query behind your report)?

when printing the report I get multiple pages.

Where is the relation to the way of counting your marks? Sorry, I don't
see it.


mfG
--> stefan <--

 

[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;

 

[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.

 

[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.

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

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!

 

[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

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.

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

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!