Recent content by bsk13

Hi. Thanks again for your suggestion and all your effort in this thread! To do it in Excel is not really easy. Seven independent (similar looking) "order files" are updated by different users spread over the company. MS access links to these seven and creates an aggregated report. All reporting...

Thanks for the fast reply. The table "orders" is not just sent back to Excel. It is joined with some huge table in our datawarehouse and used for several reports. Therefore it has to be in Access. Hmmm... this is really difficult.

Thanks! I tried the query, and unfortunately I get huge performance problems (first page after a while, then the screen locked "for ever"). Do you think there is a way to write the query to come around the performance problem? Many, many thanks for all the time you spent on my topic so far!!

Hi, I have bad news. Your query and macro runs perfect within MS Access. We are however calling an Access Query from within Excel, and there it crashes with an error message saying that the function doesn't exist. I guess macros can't be access this way. Therefore I wonder if there might be a...

Hi, there were some confusions in the conversation above, because one of my answers wasn't published (somehow "blocked" / delayed by the system). However, you are not wrong, you are right! I only need ONE instance per PartNo (and the additional data is selected from the record with the highest...

Hi again, close to the goal! I have found out that your query does the correct job. Many thanks!! But.... I however found out a problem with my data. Some of the fields orders.partno contains some trailing blanks. Blanks at the end are not actually valid. The field should always be 15...

Thanks again for your second reply! Update: I realized that I probably have done a thinking error. Your solution might work. I will check again! I tried this and I got an answer. It was however too few lines. In totalt I have 22.712 records in the table "orders". I know that 87 are double =>...

Thanks for your interest in my problem! I just want to ignore them in the result (the database itself should not be changed). Example: Partno...Date............Data1 (and Data2 etc.) abc...24th of Dec...999....(keep this record OR... abc...24th of Dec....888 ... keep this, but only one of...

Many thanks for a quick reply! Unfortunately I don't think this solution will work in the situation where I have two identical dates for a double record. Then I think I will get both of those records with the highest date (for that specific partno), not only one of them.

Hi, I (really urgent) need to get rid of double records in the result of a query. Any help would be highly appreciated! :) My database looks like this: orders.partno orders.date orders.data1 orders.data2 orders.data3 I need to write an SQL-query that gives me all the fields from the table...

Hello! I am Bjorn from Sweden, 52 ys old. I am married and the kids have now moved out. We live in the countryside and I enjoy nature and I like to listen to birds. I am eagerly waiting for internet fiber to be installed out here, to get more speed. I am quite experienced in using the built-in...