Sum Field in Same Row in ACCESS 2013

Have       TABLEWEEK  with fields

mon     tue    wed   thu   fri  sat     weektotal
 1             1                  1          1
                 1         1      1          1      

each day diferent value
i need to sum theses fields but in a row so i get the week total
how can i get it ? in access 2013
 any help please!!
MIKI RUNAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You don't sum values and store them in a Table, but you can create a Query that will sum those values:

SELECT mon, tue, wed, thu, fri, sat, mon+tue+wed+thu+fir+sat AS weektotal FROM YourTable

If any of those fields could contain a NULL value, you can use the Nz function:

SELECT Nz(mon,0), Nz(tue,0) etc etc, Nz(mon,0) + Nz(tue,0) +blah blah AS weektotal FROM YourTable
0
Rey Obrero (Capricorn1)Commented:
in a query to get weektotal

select mon,tue,wed,thu, fri,sat, nz(mon) + Nz(tue) + nz(wed) + nz(thu) + nz(fri) + nz(sat) as weektotal
from tableweek

save the query and if you want to see this in a form, use the query as the record source of the form
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MIKI RUNAuthor Commented:
Thanks !!!
0
PatHartmanCommented:
No points please.  The others have given you the bullets for your gun.

This set of columns is what is known as a "repeating group".  Each of the 7 values should be stored in a separate row in a child table.  If you read about database normalization, First Normal form discusses why repeating groups are poor practice.  In addition, you will find that since Access is a relational database rather than a spreadsheet, it has no functions that operate "across" columns in a table.  All functions operate "down" rows in a recordset.  this means that when you violate First Normal form, you are essentially on your own.  You will be writing more complex queries than would otherwise be needed and you'll probably need code also.  And, unless you are going to resolve the problem sooner rather than later, you should probably create custom VBA functions to replicate Excel functions.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.