IIF Problem on Report 1

[66tigger40]

I have the following IF Statement on a subreport but it's coming back with #error any ideas?

=IIf(Reports!AFP!VAT=True,[Nett]*17.5/100,[Nett])

The IF Statement is on a text box

Thanks

 

[KenReay]

Hi

is VAT a control on the same report? in which case try

=IIf(VAT=True,[Nett]*17.5/100,[Nett])

otherwise try

=IIf(Reports.AFP!VAT=True,[Nett]*17.5/100,[Nett])

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[66tigger40]

Great stuff thanks