Code for a formula

[sgaurav]

I am trying to implement this formula in Access that was done in Excel. Can you provide me the code for this??

=((((D17-E17)*I16)+E17)-F17)/((D17-E17)*I16)

 

[Norie]

Could you give more information on what you have in Access?

What is the formula meant to do?

 

[lovemuscle2005]

That can still be easily written.

If in a query, insert the field names instead of references. If you give me the fields I'll set it for you

 

[Ian Mac]

Can you provide more information on what you require.

Form the formula you have provided you are looking at 2 different Rows,
Access doesn't work quite the same,
it calculates all of the fields against it's corresponding row/record, if that makes sense.

It looks like you may need to have 2 queries to achieve what you need.

Here's an example for adding 2 fields in Access using the wizard:

In the field you would use:

NewValue: [Value1]+[Value2]

NewValue is the name you assign to a new field which is Value1 + Value2 (these are your field names)

The SQL for this would be:

SELECT [Value1]+[Value2] AS NewValue
FROM [YourTable];

What you need to expand on is the Value being held in the Row above in Excel as Access doesn't look at specific rows in it's calculation.

Hope that makes sense.

Regards,