Search results

you are the f***ing man!!! thanks it works now, my query is so big i need two of those in there,lol

UPDATE::: im a programmer and my mind works programmatically here is psuedo code to better undertstand what i need if ( [var rate] == 0 AND [var hours]==0) then [var costs]=[variable costs] ///the new column i will add thats not a calcualted field...

I have a variable cost that is a calculated field (as in the colum only exists in a query not as a colum in a table) that is variable hours * variable rate....the problem is ppl at my company sometimes dont know how the costs are goign to be broken down so they only put a Variable Cost.... and...

i want my data to have only 2 decimal places. So i change the property of the table to only allow 2 decimal places and i did the same to the report and they are still all over the place....for example a field would say 8.12233444 and another 1.17.....what do you think is the problem?

haha,you are the freakin man!!! all i had to do was put nz([fixed costs]) + [total variable]....thanks a bunch

what is NZ function????? you're right it probably is comming in as null, i need it to still calcualate which makes sense cuz you can't calculate a NULL

i have a query that calculates Total Costs as (total fixed + total variable). total fixed is ( fixed hours * fixed rate) and total variable is (var hours * var rate) as expected.... but one of my records only has Var hours and a Var rate,therefore calculates total variable fine, but since this...