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

Resolved · Medium Priority · Version 2007

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

Edgar has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access VBA 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.

Fri 16 Dec 2011, 19:45 Delegate 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.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips