Search results

  1. K

    Add values to releted table with VBA.

    Hi there, Tried to search, but no luck. Not easy to find such question. I have two related tables. (related with AcqID) tblAcq and tblAcqDetail In tblAcq I have information about the delivery and in tblAcqDetail delivered articles, price and quantity. tblAcq [AcqID] ; [Contractor]...
  2. K

    Help with Indexes and Duplicates!

    Hi to everyone! Have simple(as I think) question! Simply I can't find correct answer on the forum, have searched, but don't understand. I have two related Tables tblClientOrder ClientOrder ID(no duplicates); OrderDate; OrderType; Contractor tblClientOrderDetail ClientOrderDetailID...
  3. K

    Update Query with multiple criterias!

    Hi everyone, I need help with one very simply update query which I need to run. I have made a simple update query with one criteria: It works great. UPDATE tblArticle INNER JOIN qrsLimPriceNEW ON tblArticle.ArticleID = qrsLimPriceNEW.ArticleID SET tblArticle.PriceROZCoef = 4 WHERE...
  4. K

    Need help with Queries

    Hi, to everyone. I am new in forum, but hope that I can find so needed help hear. I relatively new to the Access, but until know managed to create quite a useful database. Basically it is a Price list which contains information about goods which my company is buying/selling: (Code, Description...
Back
Top Bottom