help with report

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

Hi, can anyone help. I have a few questions/
1) I want to group records by the ROAD/MTB Field, how
would I do this?.
2) then I want to open the ROAD/MTB footer. And place this
expression in the footer: =sum([COST]*[QUANTITY])
and place this label before the expression: SUBTOTAL.
3)Next on place the expression in the Report footer:=sum
([COST]*[QUANTITY]) AND Place this label before it, TOTAL
VALUE.
How would I format expressions in the ROAD/MTB AND Report
footers as currency.
Also how would I place an expression in the page footer
section to number the report=s pages.

I know I am asking alot, any help is very much appreciated

Charlie
 
Charlie said:
Hi, can anyone help. I have a few questions/
1) I want to group records by the ROAD/MTB Field, how
would I do this?.
Click to expand...

First open the report in design view.

Use the Sorting and Grouping window (View menu) and in the
Field / Expression list, select the field you want to group
on. To create a group header/footer, set those properties
to Yes in the lower part of the window.

2) then I want to open the ROAD/MTB footer. And place this
expression in the footer: =sum([COST]*[QUANTITY])
and place this label before the expression: SUBTOTAL.
3)Next on place the expression in the Report footer:=sum
([COST]*[QUANTITY]) AND Place this label before it, TOTAL
VALUE.
Click to expand...

Add a text box (Toolbox toolbar) to the footer section.
Type your expression into the text box's Control Source
property. (The properties sheet can be opened from the View
menu.) Do the same for the report footer section.

How would I format expressions in the ROAD/MTB AND Report
footers as currency.
Click to expand...

Use the text box's Format property and select Currency as
the format.

Also how would I place an expression in the page footer
section to number the report=s pages.
Click to expand...

Add a text box to the page footer section and set its
Control Source to the expression =Page or, if you prefer,
="Page " & Page
 
Back
Top