I have a Continuous Form which has 6 text boxes
There are three text boxes, Product Id, Product Name, Onhand, which is associated with the Products Table.
I have two text boxes, Received, Received Date, associated with the Products_Mtd table.
I have one text box, Usage, which is not associated with a table. This text box is a calculation of the quantity shipped in the current month and year. The Order Date is in the Orders table. The Quantity Shipped is in the Order Details table
What I need to do.
If the product was received or shipped in the current month and year, show that Product Id, Product Name, Onhand
The Received Date should be the last date it was Received in the current month and year
The Received text box should contain the total amount received in the current month and year
The Usage text box should contain the total amount shipped in the current month and year
There are three text boxes, Product Id, Product Name, Onhand, which is associated with the Products Table.
I have two text boxes, Received, Received Date, associated with the Products_Mtd table.
I have one text box, Usage, which is not associated with a table. This text box is a calculation of the quantity shipped in the current month and year. The Order Date is in the Orders table. The Quantity Shipped is in the Order Details table
What I need to do.
If the product was received or shipped in the current month and year, show that Product Id, Product Name, Onhand
The Received Date should be the last date it was Received in the current month and year
The Received text box should contain the total amount received in the current month and year
The Usage text box should contain the total amount shipped in the current month and year
