Search results

I have a tblOrders and a tblShipments. I also have a qryNewQtyDue, which takes QtyDue from tblOrders minus qtyShipped from tblShipments. So it gives me a balance due. Is there any way to take this "balance due" and update it to QtyDue in tblOrders? Example: tblOrders OrderID - 123 QtyDue -...

I want to run a report based on the query below. It is basically going to be an aging report on outstanding invoices. It will tell me how many days has passed since the invoice date. What I want the report to display is this: InvoiceID ---- InvoiceDate --- 1-30 Days --- 31-60 Days --- 61-90...

This may be a really dumb question, but those are the easiest to answer right? ;) Anyway, I have a parameter query where the user enters in certain criteria that it wants to look up. If there are no results that pertain to what a user enters in, is there a way that I can put in an error...

I want a query that will append a date from one table to another, however I want it to incriment by one day. Is this possible? For example: tblTable1 07/20/2005 07/25/2005 07/28/2005 ActionQuery - tblTable1 appends to tblTable2 and incriments one day: tblTable2 07/21/2005 07/26/2005...

I have an Invoice Form with a Payments Subform. Here are the details: frmInvoice InvoiceID Customer ShipmentID QtyShipped UnitPrice frmPaymentsSubform PaymentID InvoiceID CheckNum DateReceived Amount An invoice can be paid in multiple payments. (One-to-Many Relationship). I have a calculated...

I'm a first time poster and have only a basic knowledge of Access. I have two tables: tblShipments and tblOrders. tblOrders has a primary key of Order# tblShipments has a primary key of Shipment# Each ONE Order can have MANY Shipments (we sometimes ship partial orders). In tblOrders, I have...