We help IT Professionals succeed at work.

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



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));

Open in new window

Comment
Watch Question

HainKurtSr. System Analyst
BRONZE EXPERT

Commented:
SELECT [MTGLIBP1_CHMSTR01#].[ACCT#]

means select ACCT# column from table MTGLIBP1_CHMSTR01#
HainKurtSr. System Analyst
BRONZE EXPERT

Commented:
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?
SILVER EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
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.

SILVER EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
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.

SILVER EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
A query that selects data from another database would have an IN clause specifying the path to that database.
Allen PittsBusiness analyst

Author

Commented:
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.

HainKurtSr. System Analyst
BRONZE EXPERT

Commented:
89MB! you should have table

create a new query and put this and run it, what do you see

select * from [MTGLIBP1_CHMSTR01#]

Commented:
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.
Commented:
Otherwise, the tables have been deleted.  If even if the tables were linked and source was deleted, you would still see the table name in your db, but if you tried to open it you would get an error msg.
Allen PittsBusiness analyst

Author

Commented:
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

Commented:
The person who created the bd proably meant for those queries to be run in that order.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.