Subtotal in group footer shows only last detail row, not total

[SRussell]

I have a =Sum([CntStatus]) where CntStatus was a counted occurrence grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and it's #'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen

 

[Duane Hookom]

It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the report?

 

[_Stephen]

It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the
report?

this was a very simple query of
Select Job.CustomerID,Customer. Customer.Name, Job.Status, Count(Job.status)
as cntStatus
from Jobs left join Customers on Jobs.customerID = Customers.customerID
where JobEndDate between (Ref to form!StartDate and Ref to Form.EndDate)
group by Job.CustomerID,Customer. Customer.Name, Job.Status
order by Customer.Name, Job.Status

I see between 1 and 3 rows per customer in the query. I see the same rows
in the report. Unfortunatly I don't see the
=sum(cntStatus)
that is in the control on the form.

Any ideas?

Thanks for the reply.

I have a =Sum([CntStatus]) where CntStatus was a counted occurrence
grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and it's
#'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen

 

[Duane Hookom]

I was with you until "that is in the control on the form". Aren't we
referencing a text box in a group footer on a report?

--
Duane Hookom
MS Access MVP

It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the
report?

this was a very simple query of
Select Job.CustomerID,Customer. Customer.Name, Job.Status,
Count(Job.status) as cntStatus
from Jobs left join Customers on Jobs.customerID = Customers.customerID
where JobEndDate between (Ref to form!StartDate and Ref to Form.EndDate)
group by Job.CustomerID,Customer. Customer.Name, Job.Status
order by Customer.Name, Job.Status

I see between 1 and 3 rows per customer in the query. I see the same rows
in the report. Unfortunatly I don't see the
=sum(cntStatus)
that is in the control on the form.

Any ideas?

Thanks for the reply.

I have a =Sum([CntStatus]) where CntStatus was a counted occurrence
grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and it's
#'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen

 

[_Stephen]

I was with you until "that is in the control on the form". Aren't we
referencing a text box in a group footer on a report?

Damn, yes that is what I mean, a textbox on the report that has the =sum()
command but it fails to see more the the last record.

It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the
report?

this was a very simple query of
Select Job.CustomerID,Customer. Customer.Name, Job.Status,
Count(Job.status) as cntStatus
from Jobs left join Customers on Jobs.customerID = Customers.customerID
where JobEndDate between (Ref to form!StartDate and Ref to Form.EndDate)
group by Job.CustomerID,Customer. Customer.Name, Job.Status
order by Customer.Name, Job.Status

I see between 1 and 3 rows per customer in the query. I see the same
rows in the report. Unfortunatly I don't see the
=sum(cntStatus)
that is in the control on the form.

Any ideas?

Thanks for the reply.

I have a =Sum([CntStatus]) where CntStatus was a counted occurrence
grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and it's
#'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen

 

[Duane Hookom]

I find it hard to believe a text box with:
=Sum([your field])
would not sum Your field over the group. Try create a new report and keep it
simple. See if the same issue appears.


--
Duane Hookom
MS Access MVP

I was with you until "that is in the control on the form". Aren't we
referencing a text box in a group footer on a report?

Damn, yes that is what I mean, a textbox on the report that has the =sum()
command but it fails to see more the the last record.

"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the
report?

this was a very simple query of
Select Job.CustomerID,Customer. Customer.Name, Job.Status,
Count(Job.status) as cntStatus
from Jobs left join Customers on Jobs.customerID = Customers.customerID
where JobEndDate between (Ref to form!StartDate and Ref to Form.EndDate)
group by Job.CustomerID,Customer. Customer.Name, Job.Status
order by Customer.Name, Job.Status

I see between 1 and 3 rows per customer in the query. I see the same
rows in the report. Unfortunatly I don't see the
=sum(cntStatus)
that is in the control on the form.

Any ideas?

Thanks for the reply.


I have a =Sum([CntStatus]) where CntStatus was a counted occurrence
grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and it's
#'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen

 

[SRussell]

I find it hard to believe a text box with:
=Sum([your field])
would not sum Your field over the group. Try create a new report and keep
it simple. See if the same issue appears.

I did make a second version of the report and it worked as it should. ?????
I then added report footer and coppied the same formulat to there and it
worked like is should. Go figure!

Thanks.

__Stephen

Duane Hookom
MS Access MVP

I was with you until "that is in the control on the form". Aren't we
referencing a text box in a group footer on a report?

Damn, yes that is what I mean, a textbox on the report that has the
=sum() command but it fails to see more the the last record.

"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
It looks very much like your control source in the Group Footer is
=[CntStatus]
Are the other values (2, 81, 19, and 7) in the detail section of the
report?

this was a very simple query of
Select Job.CustomerID,Customer. Customer.Name, Job.Status,
Count(Job.status) as cntStatus
from Jobs left join Customers on Jobs.customerID = Customers.customerID
where JobEndDate between (Ref to form!StartDate and Ref to
Form.EndDate)
group by Job.CustomerID,Customer. Customer.Name, Job.Status
order by Customer.Name, Job.Status

I see between 1 and 3 rows per customer in the query. I see the same
rows in the report. Unfortunatly I don't see the
=sum(cntStatus)
that is in the control on the form.

Any ideas?

Thanks for the reply.


I have a =Sum([CntStatus]) where CntStatus was a counted occurrence
grouped
by Status in my query. It is INT.

I have an access book and it's samples show the same concept and
it's #'s
total. I have a jpeg to show what is happening.
www.adribbers.com/stuff/jobperf.JPG

Any ideas? This is a show stopper for delivering back to my friend.

TIA

__Stephen