Allen Pitts
asked on
Access query
Good morning Expert,
In the MS Access 2007 query copied below I believe 'SELECT [MTGLIBP1_CHMSTR01#].[ACCT #],' means select the field called 'ACCT#' from the database called MTGLIBP1_CHMSTR01#
Is that true?
Any idea what the 'Step 0010 Loans that Matured' is all about? I was given an mdb
file which has no tables just a series of queries that have names like
Step #0010 - List Loans having Matured
Step #0010a -append HH
Step #0019
Step #0020 Data Formatted
etc.
I think this a series (there are fourteen in all) of process that are part of a larger
process created in MS Access but don't have much Access knowledge.
Thanks.
Allen In Dallas
In the MS Access 2007 query copied below I believe 'SELECT [MTGLIBP1_CHMSTR01#].[ACCT
Is that true?
Any idea what the 'Step 0010 Loans that Matured' is all about? I was given an mdb
file which has no tables just a series of queries that have names like
Step #0010 - List Loans having Matured
Step #0010a -append HH
Step #0019
Step #0020 Data Formatted
etc.
I think this a series (there are fourteen in all) of process that are part of a larger
process created in MS Access but don't have much Access knowledge.
Thanks.
Allen In Dallas
SELECT [MTGLIBP1_CHMSTR01#].[ACCT#], [MTGLIBP1_CHMSTR01#].NAME1, [MTGLIBP1_CHMSTR01#].MATDTE, [MTGLIBP1_CHMSTR01#].PRIBAL, [MTGLIBP1_CHMSTR01#].LNTYPE, [MTGLIBP1_CHMSTR01#].SUBCLS, [MTGLIBP1_CHMSTR01#].CLSDCD, [MTGLIBP1_CHMSTR01#].COUNCD, [MTGLIBP1_CHMSTR01#].WARNCD, [MTGLIBP1_CHMSTR01#].LKOTCD, [MTGLIBP1_CHMSTR01#].STATCD, [MTGLIBP1_CHMSTR01#].FLDMAN INTO [Step 0010 - Loans that matured]
FROM [MTGLIBP1_CHMSTR01#]
WHERE ((([MTGLIBP1_CHMSTR01#].MATDTE)<=201110) AND (([MTGLIBP1_CHMSTR01#].PRIBAL)>0) AND (([MTGLIBP1_CHMSTR01#].CLSDCD)=1 Or ([MTGLIBP1_CHMSTR01#].CLSDCD)=9) AND (([MTGLIBP1_CHMSTR01#].COUNCD)<>71 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>121 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>265 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>465 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>466 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>469 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>602 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>674 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>675 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>280 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>297 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>480 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>424 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>74 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>425 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>112 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>115 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>157 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>687 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>876 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>998 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>96 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>276 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>401 And ([MTGLIBP1_CHMSTR01#].COUNCD)<>933) AND (([MTGLIBP1_CHMSTR01#].WARNCD)<>3 And ([MTGLIBP1_CHMSTR01#].WARNCD)<>5 And ([MTGLIBP1_CHMSTR01#].WARNCD)<>4) AND (([MTGLIBP1_CHMSTR01#].LKOTCD)<>3 And ([MTGLIBP1_CHMSTR01#].LKOTCD)<>4 And ([MTGLIBP1_CHMSTR01#].LKOTCD)<>9));
are you sure there is no table?
this should be a table
[MTGLIBP1_CHMSTR01#] or a query
maybe it is a linked table
how big is your mdb?
this should be a table
[MTGLIBP1_CHMSTR01#] or a query
maybe it is a linked table
how big is your mdb?
This is a make table query.
You're understanding the SELECT part correctly. MTGLIBP1_CHMSTR01# is the source table or query.
'Step 0010 Loans that Matured' is a target table for the output of this query.
You're understanding the SELECT part correctly. MTGLIBP1_CHMSTR01# is the source table or query.
'Step 0010 Loans that Matured' is a target table for the output of this query.
If there are no tables in the database then it is possible that your queries are selecting data from tables in another database, or there is possibly a second database (probably data tables only) whose tables should be linked to this database.
A query that selects data from another database would have an IN clause specifying the path to that database.
ASKER
The database is 89 megabytes.
Do you know what created the steps?
Step #0010 - List Loans having Matured
Step #0010a -append HH
Step #0019
Step #0020 Data Formatted
Step #0020a
Step #0025 CHESCRAB
Step #0032 Loans w/no PMI
etc.
Do you know what created the steps?
Step #0010 - List Loans having Matured
Step #0010a -append HH
Step #0019
Step #0020 Data Formatted
Step #0020a
Step #0025 CHESCRAB
Step #0032 Loans w/no PMI
etc.
89MB! you should have table
create a new query and put this and run it, what do you see
select * from [MTGLIBP1_CHMSTR01#]
create a new query and put this and run it, what do you see
select * from [MTGLIBP1_CHMSTR01#]
Check to see if the tables are hidden. Show hidden objects. Right click on the header of the navigation pane (it may say All Access Objects, or tables, or Queries). Select Navigation options and check the box to show hidden object.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The hidden objects tip was great.
There are 12 tables in the database .that have a an icon that looks like a spreadsheet table. There twenty-three tables with icon thatt looks planet earth. When plaent earth tables are clicked on the result is 'ODBC - connection to MTGLIBP1 failed'
So the spreadsheet tables seem to be utility ables that are used with queries to create data from
MTGLIBP1 database.
But what about the steps?
will accept as solution
There are 12 tables in the database .that have a an icon that looks like a spreadsheet table. There twenty-three tables with icon thatt looks planet earth. When plaent earth tables are clicked on the result is 'ODBC - connection to MTGLIBP1 failed'
So the spreadsheet tables seem to be utility ables that are used with queries to create data from
MTGLIBP1 database.
But what about the steps?
will accept as solution
The person who created the bd proably meant for those queries to be run in that order.
means select ACCT# column from table MTGLIBP1_CHMSTR01#