The names for the qty fields are Discrepancy Qty and Discrepancy 2 Qty.

I'll refer to your "printable form" as a "report" below, for clarity's sake.

As it stands now, you need to put a textbox in every row and column on the report, and use an IIf() function in every box to check if data should be put in row 1 column 1, r1 c2, r1 c3, ... r2 c1, r2 c3... etc.  Your report is a 6x6 grid, so you need 36 textboxes (and checkboxes) with an IIf() in the control source of every one of them.  So it's not very efficient.  And that is because your table doesn't seem to be "normalized."

Instead of putting like items in separate columns (like your Discrepancy Qty 1 and 2), normalization recommends that you put them in the same column but different rows.  Figure 1 below shows what your table would look like, if normalized.

With a crosstab query (similar to pivot table in Excel) as shown in Figure 2, you can transform your normalized table into a different row-column arrangement.  The crosstab query produces a result as shown in Figure 3.

Note that Figure 3 has the exact same layout you need for your report -- the 3 units of scrap qty is in row 1 column 4, the same place you need it on the report.  You just need to have your report print each row accordingly, and all the data will fall into the right columns.  This will save you a lot of work in setting up the report.  And that's all because the table is set up correctly.

This site has courses on normalization and crosstab query, which are pretty big and important topics in database.

Hello Kevin,

I'm just now getting back to work after an illness. Thank you for your response. I was afraid you were going to say that. I already anticipated that was the route I was going to have to take. I will work on this over the next couple of weeks and will let you know if I run into any issues.

Have a Merry Christmas and a Happy New Year!

Stephen