Hope someone can help. I'm a non-programming noob.
I've a table that contains details about components a client wants priced (component name, length, width, detail1, quantity of detail1, detail2, quantity of detail2)
Sometimes the client will require 1 detail, sometimes 2, sometimes none.
I've created a report that takes the data from this table and displays it in the following layout as well as performing claculations based on the data entered in the table (essentially the report is the Estimate I want to hand out to the client);
(component name) of size (length) x (width)mm. = £##.##
(quantity of detail1) x (detail1)
(quantity of detail2) x (detail2)
This works, and displays, fine when each component has two details, however when only one, or no details are required (and the table cells have therefore been left blank) then there are lines with " x " only showing.
How can I get the report to do something like "If cell = blank, then don't print (quantity) x (detail)"?
Thanks in advance