IIf fUNCTION

[Ryan0001]

ive got an invoice for a mail-ordering system. ive also got a form to enter in the order details. if a certain condition is met i need a table with various headings and values to be inserted. if this condition is not met, i don't want the table to be inserted. i managed to do this by having IIf functions for the headings and values in the table, which worked. however, the problem is that i can't do an IIf function for the actual tables and the lines in it...therefore they are always displayed. so i need to find out how to use an IIf function for lines (the table basically) or if there's another way of getting round this problem... appreciate any help

 

[randysmid]

Hi,
Is this for a form, or a report. If it is for a form, then you should try another forum (forum702 If this is for a report, then I don't understand the problem.

HTH,
Randy Smith
California Teachers Association