Recent content by Sportman1975

First of all: I have build some nice queries but I'm stuck right now. And I think it's relative easy to solve. Table 1: Stamtabel clients (clients master table [no unique id]) Field name 1 Klantnaam (text) 2 klantnummer (text) 3 Max age (number) 4 Finance (text) 5 Nog te vorderen (number)...

Tnx Poppa Smyrf for the great help!!!!

Hereby the requested attachment :)

First thanks a lot for your great help Poppa Smurf! Your query works great, but there's a next problem ;) Column 4 contains the price of the item. The prices can change by day so the item price must be changed in the latest price. How can I adjust your macro's to arrange this? Thanks in advance.

Update-Insert macro Dear All, I'm trying to find a solution for days now and I need (a lot of) help from some real specialist. I getting a daily file htm-file which I import with a macro (TransferText macro). The problem is that the current file (let say "old") contains a lot of the same data...