We help IT Professionals succeed at work.
Get Started

Access query

454 Views
Last Modified: 2012-05-12
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
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE