Need filter or Case statements or both?

G

Guest

User selects a loan number from a cbo. The loan numbers start with 010, 020,
040 or 041 and looks like this 040-00002006. I need to show the correct
condition codes for each group (tabs in subforms) that is associated with the
first three numbers of the loan. How do I do this?

Example 1:

Loan Number: 041-00002877


Condition Code ..................... Group Name

10 ......................................... Borrower
160 .......................................Borrower
23 .........................................Borrower
11 .........................................3rdParty
100 .........................................Zoning
101.........................................Zoning

Example 2:

Loan Number: 040-00001999


Condition Code ..................... Group Name

106 ......................................... Borrower
99 .......................................3RDParty
233 .........................................3rdparty
44 .........................................Zoning
345.........................................Zoning
75.........................................Zoning
 
G

Guest

Can you restate your question, please? It is confusing. I can't tell if you
want to return a group name based on a condition or a conditiona based on a
group name nor do you state how I know the value of the one I need to use to
return the other.
 
G

Guest

No i have codes stated above that are associated with certain group names and
those group names and codes go with certain loan numbers. Each loan number
starts with a 040, 041 etc.

Make sense
 
G

Guest

No
--
Dave Hargis, Microsoft Access MVP


TKM said:
No i have codes stated above that are associated with certain group names and
those group names and codes go with certain loan numbers. Each loan number
starts with a 040, 041 etc.

Make sense
Click to expand...
 
G

Guest

Scarcastic is okay.
You can't seem to state your question clearly and concisely, so you will
have difficulty getting an answer.
I really was trying to help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Question showing Data 1
Adding a filter to a form 6
WCG Stats Wednesday 04 July 2012 5
FS LARGE FORMAT scanners , INKJET printers , inkjet plotters (hp designjet) , 11x17 color laser $199 0
FS inkjet plotters AND continous feed 36 inch scanners 0
FS epson receipt printer $99 , seiko label printers $49 symbol barcode guns $75 intermec wireless ba 0
FS PRINTER PARTS trays fusers drums printheads -- oki fujitsu hp genicom epson ibm dec jetdirect las 0
HP color laser $299 includes jetdirect ethernet card - extra toners NEW $20, also hp 8500 $700 8550n 1

Top