Recent content by jnr927

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...

Thanks - I'll give it a try!

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...

Hey, I have one other problem with this. Just to "refresh" you - I have a form with a subform: frmInvoice TotalDue TotalPaid (References txtMySum in subform footer) TotalRemaining (Calculates difference between TotalDue and TotalPaid) frmPaymentsSubform Amount (user entered) txtMySum (In form...

Thanks! JNR

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...

Thanks guys - it worked! :)

Tried doing this, but nothing shows up because the subform is a Datasheet Form, so when it is viewed there is no header or footer.

They were unbound fields I added into the form. The control source for TotalPaid is =Sum(Forms![frmPaymentsSubform]![Amount]) and my control source for TotalRemaining is =[TotalDue]-[TotalPaid]. Instead of the answers from those calculations displaying, I get #Error.

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...

NEVERMIND!

Thanks RV, you're the best. JNR

I can display everything I need into forms - which is fine because that is how information is going to be viewed most of the time. My only problems now, are that I have an Update Query called qryCloseOrders. It will be run daily in order to close all orders that have '0' remaining items to be...

Okay, everything works. However, when I run the query, how do I get the values to tblOrders? I want to be able to open tblOrders and see that an order has been placed for 10 parts, but only 5 have been shipped, so there are 5 remaining on order. Appending it doesn't work because of the primary...