Recent content by bartoni

I was hoping to create an automated process as ive got 20 queries to run and wanted then to all be run using one macro and pasted into certain sheets in a workbook with minimal user intervention. Any ideas? Ian

Ive got 2 tables. Table 1 contains different products and Year 1 sales. Table 2 contains the same prds but also the department which catogorises each prd. Each dept is represented as a code. What I'd like to do is to write a query that combines Prd, year1 sales and dept into 1 table. Ive done...

Hi. Ive got a list of 10 querys which i would like to transfer to Excel into the relevatn query worksheet within a workbook called test.xls i.e table1 should transfer to test.xls and into the worksheet named table1. Can anybody start me off. Is it best to write the macro in Excel or Access and...

Hi Heres the query and result (attached). Now I would like the count of prds side by side rather than on top of each other so that it has: Prd Count across a row and then the varying keys (1 and 2) Key as the column eg.: Key(1) Key(2) Prd count 55...

Hi, this is my first post so forgive me if its a bit simple.... Ive got a table with a list of product names in column 1 called "prd" and next to that column they are assigned a value of 1 or 2 (in column 2 called "Key"). How do I write a query that tells me how many products are in catogory 1...