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

doing division data one

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

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

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.