Search results

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, 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...