Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pointing to the full list from a database query
Hi there, I have an excel sheet where there's a SQL query which grabs a few columns from an access database. Actually there are two or more SQL queries on the same sheet, and I search for a number X, and query 1 gives me a few columns related to X from one access database, and Query 2 gives me a few columns more on X from another database. Query 1 starts at in sheet 'Data!B2' and query 2 starts 2-3 rows below the last row in query 1. Sometimes that is just a single row from both queries, sometimes it means I get 10 rows of data each. Now, I want to work with the data from one of the columns from one of the queries, no matter how many rows the column has (it changes with value for X) What's the best way to do this? I don't like the idea of having the data on lots of different sheets.. would like to have all of the queries (there are more to come later) on the same 'data' sheet and after I've worked with the data, instance what I need to an 'overview' sheet. any good ideas? K. -- Kashgarinn ------------------------------------------------------------------------ Kashgarinn's Profile: http://www.excelforum.com/member.php...fo&userid=7951 View this thread: http://www.excelforum.com/showthread...hreadid=512298 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access import query list incomplete | Excel Worksheet Functions | |||
ODBC database query | Excel Discussion (Misc queries) | |||
Excel Database Query | Setting up and Configuration of Excel | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Dependent List Query | Excel Worksheet Functions |