| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i join 2 "dqy" type queries in excel 2003
I'm trying to use the query function within excel instead of Access. If I
really can't join two different queries the function is not much good to me. However, if there is a way, then I can develop many reports for our end users without trying to teach them Access. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i join 2 "dqy" type queries in excel 2003
What do you mean by join 2 dqy qureies together... Are you wanting to union 2
recordsets together? Or do you want to use the returned recordset from one query as the input for the next query? Chances are what you want to do is to just write a single query that returns the recordset you need by using the Unions statement or embedding a select statement into the where clause or... -- HTH... Jim Thomlinson "Joe" wrote: I'm trying to use the query function within excel instead of Access. If I really can't join two different queries the function is not much good to me. However, if there is a way, then I can develop many reports for our end users without trying to teach them Access. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any plan to incorporate an "Excel 2003 Menu type" structu | Excel Discussion (Misc queries) | |||
| Web Queries and how Excel sees the "selected box" on the web page | Excel Discussion (Misc queries) | |||
| When I type "BVE" in a cell, it automatically chanegs to"BE"..Why | Excel Discussion (Misc queries) | |||
| When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
| Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
Hybrid Mode
