Recent content by solsearcher

Thanks a lot it works.....:)

THANKS I'll do some research.

Hello, I'm sure this a job for an Excel macro but I'm a newbie and have tried loads of methods to get this to work. I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in...

I have an xls file with macros embedded that needs updating on a daily basis. The data I need to update this sheet is in an Access database table. I have created a select query to obtain the correct data to be exported but that's about my limit. It would be a great help if somebody could...

Could you just explain how to add the new saved query to the first query that I saved. I have uploaded a screen shot but the forum will not allow me to display it. I think everything else is done

I can see why now. Duplicates are being added, this seems to be throwing them out of sync. Any idea how to remove the duplicates?

Query results in seperate columns not matching The results for these queries don't match. The sName 65887 refers to a front image for a product and the sName 65877 refers to the back image for the same product. Not all products have a front and back image so I'm guessing that's why the order...

Can't thankyou enough. Thanks for taking the time out for this one.

Thanks for your help. I really didn't know if with "unions" I was barking up the wrong tree.

Hi Forum, I'm a newbie to Access and have been thrown in at the deep end to gather information from multiple tables and export that data into excel. If I could have some help to solve this first problem I think the rest will be straight forward. Fingers crossed. First problem then..... I...