Search results for query: *

I have an access database with files linked to Mas90 4.05. I have created a new DSN and set it up with the Company Id and User Id for Login. If I use Excel to test, it does not ask me to login and brings in the data from the correct company. I linked the tables in my access database using this...

Original Code UPDATE CustomerService AS CS INNER JOIN AR_95_UDF_ARInvoiceLines AS Inv ON (CS.[Next Date]=Inv.Nextservicedate) AND ((CS.ID)=Inv.Scheduleid) SET CS.[Previous Date] = CS.[Next Date], CS.[Next Date] = UpdateServiceDates(CS.[Next Date],CS.Interval,CS.Frequency); Changed To add an...

We had someone help us write this code and now they are gone and the client wants changes. Currently we update the Access database (Customerservice) by matching with a Mas90 table. Everything was fine, but we were calculating the next date based on what was the last next date in access, they...

I have the following working code to create a file with a price matching to the price file on Item number and price level. I now need to check for the price based on Customer number and item number besides Item number and Price Level. The pricing will be one or the other, but not both. This...

I am looking for a price, but the Price file could match on Item Number and Price Level or on Item Number and Customer Number. I can get each one to work, but I do not know how to combine them. Works for Price Level Lookup =DLookUp("[DiscountMarkupPriceRate1]","All Prices Query","[ItemNumber]...