How Do I add a field on a Report

  • Thread starter Thread starter Alex access
  • Start date Start date
A

Alex access

Hello,

I'm trying to add different amounts from one field (Bid amount) using a
text box at the reports footer.

Per example:

Project amount
---------------------
Lowes $1200
Spike $1500

How can I add these two amounts on the footer of the report? can some one
help me please. I tried =[amount] but this only shows the last amount it
doesn't add them for a total. any help is appriciated.

-Alex
 
Nothing I get an this error: #error
anymore suggestions please?


KARL DEWEY said:
Try =Sum([amount])

--
KARL DEWEY
Build a little - Test a little


Alex access said:
Hello,

I'm trying to add different amounts from one field (Bid amount) using a
text box at the reports footer.

Per example:

Project amount
---------------------
Lowes $1200
Spike $1500

How can I add these two amounts on the footer of the report? can some one
help me please. I tried =[amount] but this only shows the last amount it
doesn't add them for a total. any help is appriciated.

-Alex
Click to expand...
Click to expand...
 
Try =Sum([Bidamount])

If your name has a space between Bid and amount you should get rid of it.
Proper naming of fields are naming them with no spaces unless it's in the
caption.

Alex access said:
Nothing I get an this error: #error
anymore suggestions please?


KARL DEWEY said:
Try =Sum([amount])

--
KARL DEWEY
Build a little - Test a little


Alex access said:
Hello,

I'm trying to add different amounts from one field (Bid amount) using a
text box at the reports footer.

Per example:

Project amount
---------------------
Lowes $1200
Spike $1500

How can I add these two amounts on the footer of the report? can some one
help me please. I tried =[amount] but this only shows the last amount it
doesn't add them for a total. any help is appriciated.

-Alex
Click to expand...
Click to expand...
Click to expand...
 
Back
Top