If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
crosstab query and main table
Here is the db with sample data.
http://download.yousendit.com/AAA18BC7520F196E I want to use qryCrosstab and table "ALL" to achieve the result that would look like this query "qryFinalResult". Table [ALL] has a field called filename and it stores the table name. possible ???? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200702/1 |
#2
|
|||
|
|||
crosstab query and main table
Can anyone please help ??? I tried all sorts of query but not quite hitting
the right one yet. -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
crosstab query and main table
1. I use a vba to import bunch of excel files into individual tables.
Tables are named after the excel file. A field is created in these new tables called "FileName" and it's populated with the filename. 2. I am doing this so I know what file the data came from 3. table "ALL" gets populated with all of these excel data and the name of the file. The crosstab is taking [ALL] table and aggegating hours, comp and other data elements. FinalResult is taking the crosstab and i m doing right join to pull data from crosstab and all the data from each tables. Is there a way I can only use table [ALL] and qrycrosstab to make my look like qryfinalresult ? Is there a vba that will do right join automatically between crosstab and all the table in import (except table ALL)? Here is the query that gives me all the table name. SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "msys*" And (MSysObjects.Name) Not Like "all*") AND ((MSysObjects.Type)=1)); -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200702/1 |
#4
|
|||
|
|||
crosstab query and main table
Forum Owners: DELETE THIS POST IF NO ONE GOING TO ANSWER IT. I AM REALLY
FRUSTRATED. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200702/1 |
Thread Tools | |
Display Modes | |
|
|