Boss wants his report changing again - need help quick!

[Guest]

Hi there
I have a report which lists the number of orders we have against customers.
The 'order type' is D, D*, P, P*,C or C*.
At the bottom of the report I have a total whic say s the total number of
orders is .. using the following =IIf([HasData],Count(Qty]),0)
My boss wants it sepearating to it shows as
The total number of D, D* orders =
P, P* orders =
C, C* orders =

Any help would be greatly appriciated
baz

 

[Tom Lake]

Hi there
I have a report which lists the number of orders we have against
customers.
The 'order type' is D, D*, P, P*,C or C*.
At the bottom of the report I have a total whic say s the total number of
orders is .. using the following =IIf([HasData],Count(Qty]),0)
My boss wants it sepearating to it shows as
The total number of D, D* orders =
P, P* orders =
C, C* orders =

Any help would be greatly appriciated
baz

You can group on just the first n letters of a field so that all the D's
would come out together regardless of the asterisk. Check the Sorting and
Grouping option of your report.

Tom Lake

 

[Duane Hookom]

Create a totals query based on a similar query as the main report. Use the
totals query as the Record Source of a subreport. Place the subreport in the
Report Footer section of the main report.

--
Duane Hookom
MS Access MVP

Hi there
I have a report which lists the number of orders we have against
customers.
The 'order type' is D, D*, P, P*,C or C*.
At the bottom of the report I have a total whic say s the total number of
orders is .. using the following =IIf([HasData],Count(Qty]),0)
My boss wants it sepearating to it shows as
The total number of D, D* orders =
P, P* orders =
C, C* orders =

Any help would be greatly appriciated
baz

You can group on just the first n letters of a field so that all the D's
would come out together regardless of the asterisk. Check the Sorting and
Grouping option of your report.

Tom Lake