Search results

SELECT VPO.VendorCode, VPOPayment.PaymentID, PaymentID.AccountingReference, PaymentID.PaymentDate, VPO.VPONumber, VPO.OrderDate, VPOItems.ProductID, VPOItems.TotalCost, Sum(nz(vpopayment.VPOAmountPaid)) AS [Amount Paid] FROM VPO INNER JOIN (PaymentID RIGHT JOIN (VPOItems LEFT JOIN VPOPayment ON...

I'm trying to add a date range to a form I've created with a start date and end date. Here is the code I'm using, but what do I need to change on this so that I can still continue to do queries based on other frields if the two date range frileds are blank ((VPO.OrderDate) Between...

Got kind of a weird issue... I have 4 different forms in a database. my problem with one form that I just started using recently is that it will post data to the table it's linked to, but if I close and reopen the form the record navigation buttons at the bottom don't show any of the previous...

Hi Just wondering if it's possible to have the value someone enters in a form post to a query, and then run the query based on the value entered by the user? Is there any genric examples of this? or could someone give me a brief idea how to do this? The purpose for this is so that I can...

Hi, I'm having trouble getting my 2nd combo box to work after I select a value from cboVendor1. The 2nd combo box is cboVPO1. and is on form CreateOrModifyPayment. I get the following error: Complie Error: Method or data member not found I've attached the database hoping someone can...

If a query finds a null value is It possible to write an expression that will change it to a default value like zero? As you can see from my query results VPO 333333 has a null for 'SumOfVPOAmount'. This is because I payment has not yet been made against that VPO. The purpose of this database is...

I've created a database to track payments made to vendors for Purchase Orders. In the database VPOs are paid by PaymentID and there can be more than 1 VPO in a payment ID. The problem I'm having now is that when I try to query the total balance on one or multiple VPOs, it's only showing me the...