Boss wants his report changing again - need help quick!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
baz said:
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
Click to expand...

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


Tom Lake said:
baz said:
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
Click to expand...

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
Click to expand...
 
Back
Top