MS Access 2008 calculation in query

35 pts.
Tags:
Microsoft Access 2008
Microsoft Access queries
How can I produce total marks for only last three column where is my fields and result will be:- ID 2004 2005 2006 2007 2008 2009 2010 2011 2012 Total Marks 1 6 6 6 8 0 0 0 0 0 20 2 10 10 0 10 0 8 0 8 8 24 3 6 6 6 10 10 0 0 10 0 30 4 0 0 6 10 10 10 0 10 8 28 5 0 0 2 6 6 8 0 0 0 20 6 0 0 0 8 10 8 0 0 0 28 7 8 8 8 10 10 0 0 0 0 28 8 0 0 0 0 0 8 8 10 0 26 9 0 0 0 0 0 0 10 0 0 30 10 8 0 0 0 8 0 0 0 0 24 My last field name total marks is the manual calculation result, and yes field names are year, please. Last column will be the result but how can I produce this in MS Access 2008? Kindly help?

Software/Hardware used:
MS Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Please tell us what your tables look like and what 'Total Marks' is. Also, when you say 'last three columns', are those the 2011, 2012 and 'Total Marks' columns?   When I see column headings across the top that seem to represent years, I think of crosstab queries in Access. See if that link helps you learn.   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Question appears to be a duplicate.
    50,605 pointsBadges:
    report
  • TomLiotta
    The later two posts seem to be the duplicates. But it doesn't matter much until the question makes sense. The values in the two apparent examples don't add up, so it's not clear what they represent. It looks like we're shown an output report rather than actual table columns, and 'Total Marks' is the totals. But we're not told anything about the tables, so there's nothing useful available. You can't create a process that gives output until you have some idea what the input is. -- Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Well I posted a bit of an answer on another thread that has been been removed. 
    50,605 pointsBadges:
    report
  • philpl1jb
    Are you trying to write an update query to put the total into a column in the table?  Or a query/view to show the columns plus the column which is a total?  Or a report based on the table which includes one computed field?
    50,605 pointsBadges:
    report
  • TomLiotta
    It looked like an academic exercise to me. And the lack of useful response from the OP seemed to eliminate an "IT pro" learning question. I suspect the deadline for turning in the assignment has already passed. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following