Recent content by EmileEA

Thanks for your quick reply My knowledge of excel is better than access, do you have any suggestions of how to prevent the slow down in excel?

I found it and indeed, I'm not using any indexes except for the primary key. Will it make the query faster by switching indexed to yes (with duplicates) and in ascending order on the columns which haven't been indexed?

Thanks for the quick reply Spike! The indexes option does not show in my query. I'm a complete noob at this, are indexes the only an dmost efficient way?

Hi, I'm currently working at a company where they make use of MS Access for their database. I work with an access database which my predecessor made. The database, files all sales data of the company. I file the sell-in and sell-out data on a weekly basis. This database goes back to 2009. It's...

Thanks, I was thinking way to hard on this!:banghead::D

My name is Emile and I need some help with a problem I have with a stock report. I receive a stock report every week from a customer, I would like to make an overview on a weekly basis of the stock changes. It's a list of more than 100 products every week. I tried to do a If function, vlookup...

Haha, I'll eat a cumcumber than. :cool:

Thanks a lot BigTomato! I will eat a tomato tonight to honour the help you have provided me with! You saved my day!

I understand it's just that the person who is the expert on this matter is on vacation so I'm the only person who knows a little bit of it Yes they are indeed all the same

Im very happy that you have helped me find the problem!:D Manyyyyyy Thanks!! But now my final question, can I ignore this error, since the new title will only be added this week?

Yes it does! It finds 16 records with the same itemnumber on the same platform(GameConsole).

The thing is I use the AppendQuery to get the new (Item numbers), never archived before products out of it, so it can be placed in a special list with all products. When I click the AppendQuery it first gives me you are about to append 23 rows (23 new products to a 19K long list) after that I...

Yes I'm using a append query to archive weekly sales data to the whole database, therefore some products(Item Numbers) allready exist in the destination table.

Yes I have a primary key in the table for the Item Number

Hi SmallTomato, First of all, thanks for your quick reply! All of the fields have Indexed: No Is there an easy way to trace those duplicates?