Search results

I changed the join for VPO to VPOitems and it works now.

:confused:no.... LOL sorry, still a rookie at most of this stuff. can I have a hint?

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

works now, thanks!

pasted that in and now I get no results from the query no matter what I'm searching on. is it a problem because I have the "having" clause? this is the entire code of the query SELECT VPOItems.VPONumber, VPO.VendorCode, VPO.OrderDate, VPOItems.ProductID, VPOItems.TotalCost...

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

BINGO! works now, thanks a million!

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

great! works now! thank you very much for all the help!

okay next problem.... when you are on the CreateModifyVendorPayment form the VPONumber in the subform is dependent on the vendor selected above. the Product ID is depenent on the VPONumber selected. So the combo boxes are working for the VPO Number, When I select a VPONumber from the...

yes, that is what I wanted it to do! thanks muchly for the help! :D

that's what i have in there it it's still the same restult did you download my db and change the code and itworked?

okay, I did that and it populates. however, it's only showing the VPONumbers that correlate to the first vendor selected... i.e. it's only showing VPONumbers 111111 and 125456 if you select vendor ALLFEE, if I change the vendor it's not requerying the vponumbers for then new vendor

bump... can someone look at this pleeeeease??? :)

The VPOnumber is manually entered. It is taken from our ES system at work. There's no easy way to track all these payments in the ES so I'm hoping using this database will slove a lot of our issues. Right now we're tracking everything in excel and it's a headache!

Okay, I removed VPONumber from the PaymentID table like you suggested. I also renamed all the objects with spaces, must have got lazy there. so it's still not working. I reattached it with changes. Would you mind having a look.

I made those changes and it's not showing any of the created VPOs in the subform after selecting a vendor? did it work for you?

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

yes, Nz worked. Thanks! Here is the expression I wrote: SELECT VPO.VPONumber, VPO.VendorCode, [2VPOTotalByVPO].SumOfTotalCost, Sum(nz([3PaymentTotalsByVPO].VPOAmountPaid)) AS SumOfTotalPayments, [sumoftotalcost]-Sum(nz([3PaymentTotalsByVPO].VPOAmountPaid)) AS BalanceOwing FROM...