A case statement is much nicer. Eg, for the field CardValue:
Condition = "VG" ; BookValue * 0.5 ;
Condition = "EX" ; BookValue * 0.75 ;
Condition = "EXMT" ; BookValue ;
Condition = "MINT" ; BookValue * 1.5 ;
Condition = "P" ; BookValue * 0. ;
Condition = "G" ; BookValue * 0.25 ;
Condition = "F" ; BookValue * 0.15 ;
[whatever that value C1*4 would be]
You could make your calculation more flexible for the future by maintaining a table of the multipliers, in case they changed as the market changed.
Thanks, Sorbsbuster! This worked perfectly! I really appreciate your help! :)
And with a table of the mutlipliers, you can also eliminate the need for any If or Case function if you set up the correct relationship for this table of values--which adds even more flexibility to the design and function of your database.