I have two fields on a table that has numeric values.

I'd like to create a third field where i would just like to divide the two numbers, multiply by 100 and display the results on field three.

I can't use forms or reports as i need to be able to export this information to excel.

Can this be done?

yes but dont do it in a table! make a query instead

You should not store the data. You can create a field within a query that you can export to Excel:

MyNewFieldName:[YourFirstField]/[YourSecondField]

i'll give that a shot - thanks

You should not store the data. You can create a field within a query that you can export to Excel:

MyNewFieldName:[YourFirstField]/[YourSecondField]

Little more on boBs.... you forgot the * 100

MyNewFieldName:([YourFirstField]/[YourSecondField])*100

now where in the query design view would this expression be entered...
I have worked with access doing other things but not precisely doing this...feel kind of stupid.

add the two fields to the query design.. then in the third column add

MyNewFieldName: ([YourFirstField]/[YourSecondField])*100

then change the names of the fields in the above entry

ok - thanks for both your help...did it

Little more on boBs.... you forgot the * 100

MyNewFieldName:([YourFirstField]/[YourSecondField])*100


Picky, picky, picky :D ;) :cool:

Picky, picky, picky :D ;) :cool:

haha you know it...'


Glad to help