dbTalk Databases Forums  

summing 1 row using 2 fields

comp.database.ms-access comp.database.ms-access


Discuss summing 1 row using 2 fields in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hedding
 
Posts: n/a

Default summing 1 row using 2 fields - 03-13-2006 , 05:59 PM






Hi, I am flying blind here. I am so stupid, I don't understand the
manual.... I have basicly a name database used for a sporting event
(archery) I have w columns ... one for Saturday score and one Sunday
score.... I want the total of these two scores to reflect in the last
column called Total Score

I know it will do this, I used Video professor, who does a good job
explaining things, but makes you do his projects and none of them have
this senerio. Could someone please tell me step by step on how to do
this? I use Access 2000.
Thanks,
Windy

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: summing 1 row using 2 fields - 06-03-2006 , 03:21 PM






Windi,
Open your from and select Text Box Label and enter =Sum[whatever call your
score field]

Gus

"hedding" <hedding (AT) earthlink (DOT) net> wrote

Quote:
Hi, I am flying blind here. I am so stupid, I don't understand the
manual.... I have basicly a name database used for a sporting event
(archery) I have w columns ... one for Saturday score and one Sunday
score.... I want the total of these two scores to reflect in the last
column called Total Score

I know it will do this, I used Video professor, who does a good job
explaining things, but makes you do his projects and none of them have
this senerio. Could someone please tell me step by step on how to do
this? I use Access 2000.
Thanks,
Windy

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.