Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Doing division from data in one field against data in another fi

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Doing division from data in one field against data in another fi

Resolved · Medium Priority · Version 2007

Reply Fri 16 Dec 2011, 17:35Delegate Edgar said...

Edgar has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Doing division from data in one field against data in another fi

Another basic question from an access novice. I am trying to do division calculations on access with lots of data, I know it will be easier to do this on excel but I want access to be able to perform the function as part of a query for the data base I am trying to build. What is the SQL code for instructing access to divide data in one field against data in another field and present the results of each division in a separate field? Thanks.

For upcoming training course dates see: Pricing & availability

Reply Fri 16 Dec 2011, 19:45Delegate Edgar said...

RE: Doing division from data in one field against data in anothe

Sorry, I've answered my own question, don't even need to go as in depth as SQL programming, just needed to create a calculated field.

Access articles

· Use Microsoft Access to manage your work/life balance
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· How Access Can Provide The Key To Successful Stock Management
· Why Do I Need To Use Access?
· The Benefits of Certified Microsoft Training in Access

Please browse our web site to find out more about
access 2003 training course london and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips