Recent content by mrsbean

Thanks, now how do I write a calculation in the form/query that calculates the commission amount (PurchasePrice * CommissionRate)?

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...

Thanks for the quick reply! I have tried this but I get an error message telling me the expression contains invalid syntax. I'm assuming "len" refers to the length of the field? Is there another way around this?

Thanks for your reply. The field is definitely empty and it is a text field - what is the difference between a zero length string and a null field (excuse my ignorance, I am a real hack!) and how does this affect the way the fields are displayed (or not)?

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...

thanks, now I know what an update query does as well!

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.