Reporting null or zero length fields

[cantwellt]

I have been tasked with making our invoice print out a listing of all line items, regardless as to whether they have any values in them or not. The invoice is exported from an access report to an .RTF file. It's a basic invoice that we bill once a month to our one and only customer. My people want each line item (part number) to be printed even if it has no quantity associated with it. Is this possible? I'm afraid that I'm not very much of a VB person. The invoice consists of Item#, Sum of quantity, unit cost, Sum of extended cost.

Thanks in advance for any help offered! [sig][/sig]

 

[TheInsider]

Hi,
No VB involved here! I assume that you have 2 tables, ie. a Parts table and an Orders table... in the report's query set the relationship between the 2 tables to show all records from the Parts table and only those that match in the Orders table. In the report set the field source of sum of quantity field to "=NZ(SumOfQuantity, 0)".
[sig]<p>Rob Marriott<br><a href=mailto:rob@career-connections.net>rob@career-connections.net</a><br>[/sig]

 

[cantwellt]

Rob,

Thanks for the help. Actually I have three tables. One is a lookup table for the Input Form. I also need the fields unitcost and dept. from this table. I did as you said and set the relationship of the parts table to the Orders Table. I also set the relatiionship from the parts table to this third table (partslkup) to all records from the parts table and only those that match in the partslkup table. I set the field's record source as you said and I get the old &quot;Enter Parameter Value&quot; Box when I try to open the Report. Ideas anyone? [sig][/sig]