Search results

Hi: In your reply, you state that you accidentally put in a "*" instead of a "/". The expression you gave me to try was the following. I do not see the "*" SubAreaOneLeadsL: Int([Plumbingleadspermonthl]/[subareaonepercentage]) + Sgn([Plumbingleadspermonthl] MOD [subareaonepercentage])

Hi, Thanks, but it did indeed create error messages in all records. I don't understand about what you noted about not using it if: :"It should not be used if the dividend or divisor are fractions held as Single or Double datatypes due to inaccuracies in storing base10 fractions in a base2...

Sorry, I am totally lost. I do not understand the syntax and I would ask where within the access query would I place this code? Withing the query editing screen in the field formula itself?

Hi. I am working with an Access 2000 database. I have a query that contains the following formula: SubAreaOneLeadsL: [Plumbingleadspermonthl]*[subareaonepercentage] The field, "SubareaOne percentage" (below) is a formula that uses the number of homes in an area (subareaonefsagroupnum)...