Count Check Marks

  • Thread starter Thread starter lmossolle
  • Start date Start date
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!
 
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 <--
 
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...
 
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;
 
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.
 
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...
 
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...
 
Back
Top