|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 12th, 2008, 10:25 PM
posted to microsoft.public.access.reports
|
|||
|
|||
How Do I add a field on a Report
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 
|
|
#2
June 12th, 2008, 11:56 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How Do I add a field on a Report
Try =Sum([amount])
-- KARL DEWEY Build a little - Test a little "Alex access" wrote: 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
|
|
#3
June 13th, 2008, 01:58 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How Do I add a field on a Report
Nothing I get an this error: #error
anymore suggestions please? "KARL DEWEY" wrote: Try =Sum([amount]) -- KARL DEWEY Build a little - Test a little "Alex access" wrote: 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
|
|
#4
June 13th, 2008, 07:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How Do I add a field on a Report
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" wrote: Nothing I get an this error: #error anymore suggestions please? "KARL DEWEY" wrote: Try =Sum([amount]) -- KARL DEWEY Build a little - Test a little "Alex access" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
