How Do I add a field on a Report

[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

 

[KARL DEWEY]

Try =Sum([amount])

 

[Alex access]

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

Try =Sum([amount])

--
KARL DEWEY
Build a little - Test a little

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

 

[Stockwell43]

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.

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

Try =Sum([amount])

--
KARL DEWEY
Build a little - Test a little

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