L
Larry
I have developed an inventory data base for an Optics Lab. There are several
types of lenses, and each type of lens could have as many as 135 different
sizes. i have a products table labeling each size lens. (ID Number A1 -
A33, through F1 - F33) I developed a form to enter information into an
inventory table. From the table I have an inventory activity query with the
fields "ID Number", "QTY Ordered", "QTY. Received", QTY. Issued", "QTY. On
Hand". I tried to develope a report based on the inventory activity qyery,
to give the "sum of the QTY. On Hand" for each ID Number. I'm having a
problem developing an expression in the individual text boxes on the report,
that will identify each ID Number and give it's sum of the quantity on hand.
I get a pop up (enter peramiter value) or #name. Any help with this would be
greatly appreciated.
Thank you,
Larry
types of lenses, and each type of lens could have as many as 135 different
sizes. i have a products table labeling each size lens. (ID Number A1 -
A33, through F1 - F33) I developed a form to enter information into an
inventory table. From the table I have an inventory activity query with the
fields "ID Number", "QTY Ordered", "QTY. Received", QTY. Issued", "QTY. On
Hand". I tried to develope a report based on the inventory activity qyery,
to give the "sum of the QTY. On Hand" for each ID Number. I'm having a
problem developing an expression in the individual text boxes on the report,
that will identify each ID Number and give it's sum of the quantity on hand.
I get a pop up (enter peramiter value) or #name. Any help with this would be
greatly appreciated.
Thank you,
Larry