Search results

Please advise on the best way to go about performing a calculation for commission earned on a sliding scale according to purchase price. E.G. if the purchase price is between 0 and 500, commission is 5% ; if the price is between 501 and 999, commission is 5.5% and so on. Also, is there a...

Hi I am working in Access 97 and would like to "join" fields in a report using the IIf statement. This is what I have so far: =IIf(IsNull([Job1]),"",[Job1]) & IIf(IsNull([Job2]),""," / " & [Job2]) The problem is that the "/" character is displayed regardless of whether the fields are empty...

Is there any way of automatically "checking" check boxes on a number of records (eg with a Find and Replace type of macro), and then "unchecking" all check boxes on a form? Please help, bearing in mind my programming skills are almost non-existent! Thanks.