Summing Text Boxes on Access Form (1 Viewer)

craigger01

New member
Local time
Today, 00:38
Joined
Feb 11, 2018
Messages
3
Hello!

Notice the attachment. I'm trying to get the text box labeled "Gross Revenue Total" to simply display the sum of the other 12 text boxes, which are labeled by months and in CURRENCY format. I want "Gross Revenue Total" to simply be a display that updates the sum of the boxes AS I'M ENTERING them. I'm not sure what the code is for this or where to put it in the properties box.

Any help will be appreciated.

Please speak in layman's terms because I'm not real sure what "focus" or any of the intricate terms mean. Thanks!
 

Attachments

  • ScreenHunter_50 Feb. 11 11.45.jpg
    ScreenHunter_50 Feb. 11 11.45.jpg
    103.4 KB · Views: 123

pbaldy

Wino Moderator
Staff member
Local time
Today, 00:38
Joined
Aug 30, 2003
Messages
36,118
You'd need to add them up:

=JanuaryTextbox + FebruaryTextbox +...

Hopefully you're not going to store data that way.
 

missinglinq

AWF VIP
Local time
Today, 03:38
Joined
Jun 20, 2003
Messages
6,423
Think you'll need to account for Nulls, in the 'month Controls,' as well:

=Nz([JanuaryTextbox],0) +Nz([FebruaryTextbox],0)+...

Linq ;0)>
 

craigger01

New member
Local time
Today, 00:38
Joined
Feb 11, 2018
Messages
3
Ok, thank you all for your responses. But, please, be more specific. Do I put that syntax into the Gross Revenue Total text box? And, if so, where do I put it? In BeforeUpdate?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 00:38
Joined
Aug 30, 2003
Messages
36,118
Control source.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 00:38
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom