I want to create a query that will update a few fields with the same user-entered parameter. We freqently change our customer numbers and I need a way to update 3 or 4 tables at the same time when the user enters a number. For example: custmast.custnum = 123456, actsum.custnum = 123456...
I am reading three tables and trying to get the best vendor number from all three. I keep getting wrong number of arguments. Can someone help? Thanks!
vendr: (IIf(IsNull([salesfil]![VENDOR_NUMBER]) And IsNull([OAUSER_ITEMLU1]![VENDOR_NUMBER]) And...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.