Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses in london - Query Sums
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access courses in london - Query Sums
Resolved · Low Priority · Version Standard
Reply Thu 6 Sep 2007, 16:11Delegate Sacha said...
Sacha has attended:
Excel VBA Intro Intermediate course
Access Introduction course
Query Sums
How do I automatically sum amounts in a query?
For upcoming training course dates see: Pricing & availability
RE: Query Sums
Hi Sacha
You can do this in the SQL within MS Access. The code you need will be very similar to:
Select sum(myfield) From mytable
Hope this helps
David
|