View Single Post
Old 10-12-2006, 12:12 AM   #2
rborob
Registered User
 
Join Date: Jun 2006
Posts: 116
Thanks: 0
Thanked 3 Times in 1 Post
rborob is an unknown quantity at this point
thats very messy

Dim a, b, c, d as double
a = Me.[Quantity_Ordered]
b = Me.[Price]
c = Me.[Discount]
d = ((a*b) - (b*c))
Me.[Line_Item_Cost] = d

tidier. not sure where the problem is though...can you post the database to look at?
rborob is offline   Reply With Quote