Recent content by kyle18

Basically I have a field [LimPrice] in [tblAcqDetail] I need to calculate it by adding to a field[acqPrice] cost of transport which is calculated in [tblAcq] by (transport divided by cost of shipment). But I don't understand how. Because transport cost is calculated once for whole shipment but...

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

I found it.. Thanks for reply, sometimes it is one word which makes the difference!!

Can you be more specific at how you make it? Thanks!

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

The reason why I am using Append query is because I am not really experience SQL and its functions. How would I use SELECT?

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

Thanks for help, Your hits gave me a clue where to look, so I did Append Query: INSERT INTO tblPrice (ArticleID) SELECT tblArticle.ArticleID FROM tblArticle LEFT JOIN tblPrice On tblArticle.ArticleID = tblPrice.ArticleID WHERE (((tblPrice.ArticleID) is Null)); Works like charm. Thanks for...

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