Choosing among multiple formulas

[Mister M]

I am repeatedly calculating the same thing and want to make a simple database to make life simpler.



i have a job table, the employees table and a truck table (there are 3 or 4 different size rigs). I have 4 different formulas that i must choose among for calculating their mileage fee.

i am very new to access and wonder what the simplest way is to choose among 4 different formulas to calculate the fee

[June7]

Post your formulas for analysis. What are the rules for choosing?

[isladogs]

You need to define your 4 conditions e.g. RigSize = "Small" or "Medium" etc then use one of these :

a)

If Condition1 Then
 'condition1 code here...
ElseIf Condtion2 Then
 'condition2 code here...
ElseIf Condtion3 Then
 'condition3 code here...
Else 
 'condition4 code here...
End If

OR use Select Case which is neater & may run slightly faster

Dim intCondition As Integer

Select Case intCondition

Case 1
'condition1 code here...
Case 2
'condition2 code here...
Case 3
'condition3 code here...
Case 4
'condition4 code here...
End Select

[orange]

In addition to the advice/comments so far, I recommend you tell us in simple English what information exactly will you use/get from this proposed database. There may be some options or more info relevant to the database and its design if we knew more about it.
Good luck with the project and welcome to the forum.