One day I will finish this database and leave you alone. Latest problem is that I have a query to calculate aged debts - it works very well so far.
I have used expressions to get line total/VAT/Total and Balance outstanding. One expression leading to the next so balance oustanding is expr4-expr3.
However this returns a list of all people who have ordered anything. I have tried IsNotNull, >0, >£0, Between 0 and 999999, etc ad nauseum, but each criteria brings up a parameter query box asking for a value for EXpr3. I assume that this is because the field is based on a formula.
Any clever ways around this? I can't upload the d/b it's too big but happy to e mail it.
I have used expressions to get line total/VAT/Total and Balance outstanding. One expression leading to the next so balance oustanding is expr4-expr3.
However this returns a list of all people who have ordered anything. I have tried IsNotNull, >0, >£0, Between 0 and 999999, etc ad nauseum, but each criteria brings up a parameter query box asking for a value for EXpr3. I assume that this is because the field is based on a formula.
Any clever ways around this? I can't upload the d/b it's too big but happy to e mail it.