doing division data one

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

resolvedResolved · Medium Priority · Version 2007

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.

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 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


Server loaded in 0.08 secs.