calculation _expression_ in a query and then sort that.
SELECT Field1, Field2, Field3, (Field1 + Field2 + Field3) As RowTotal
FROM MyTable
On the query design grid, you would enter:
RowTotal: Field1 + Field2 + Field3
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of irelandmorro
Sent: Saturday, May 13, 2006 1:12 AM
To: [email protected]
Subject: [ms_access] creating a calculated field in a table
Is it possible to create a field in a table which takes it value from
the Sum of other fields in the same record?
I have 10 number fields in a table and I want to add another field
which stores the sum of those 10 fields. I have been able to add an
unbound control to a form that's based on this table. But I can't sort
the form on this control and I guess the reason is because it's unbound.
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
