Unique expression under same field name

[nygiantsfan]

Hi all,

I am trying to create a field in which each row has it's own unique expression for calculation. For example I want a field titled utility; however, John's equation for utility is different from Mary's calculation. I want Access to calculate both of these utilities under the same field (column) entitled utility utilizing a given equation that manipulates other fields within the table. Any help would be very much appreciated . Hope you all had a great weekend!



-nygiantsfan

[JoeM]

Welcome!

I would recommend creating a User Defined Function. You can pass in the user name as one of the variables, and have it calculate differently for them.
See here for User Defined Functions: http://www.fontstuff.com/vba/vbatut04.htm

I would probably use Case statements for each different user/calculation (http://www.techonthenet.com/access/f...anced/case.php), i.e.

Select Case UserName
    Case "John"
        ' Do John's calculation here
    Case "Mary"
        ' Do Mary's calculation here
    ...
    Case Else
        ....
End Select

[rpeare]

You could also define the calculation you want to perform per employee in a table and use that to do the calculation, just substituting in values from your table into the formula.