Advance Query Help

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Hello all,
I need help with a query in automating a process that is
currently being done with a spreadsheets and requiring a
great deal of man hours.
I have TABLE-1 and TABLE-6 in my database TABLE 2,3,4,5
are links to other databases to collect the needed data.
Here are the steps we use to get our reporting:

TABLE-1 [A1],[A2],[A3],[A4],[A5]
TABLE-2 [B1],[B2],[B3],[B4]
TABLE-3 [C1],[C2],[C3],[C4],[C5],[C6]
TABLE-4 [D1],[D2],[D3],[D4],[D5]
TABLE-5 [E1],[E2],[E3],[E4],[E5],[E6]
TABLE-6 [F1],[F2],[F3],[F4]

STEP-1 FROM TABLE-1 LOOKUP [A3] IN TABLE-2[B1] TO GET
VALUE FOR [B2]
STEP-2 FROM TABLE-1 LOOKUP [A4],[A5] AND [B2] FROM TABLE-
2 TO GET VALUE FOR [C6]
STEP-3 FROM TABLE-3 LOOKUP [C6] IN TABLE-4 [D4] TO GET
VALUE FOR [D2]
STEP-4 FROM TABLE-4 LOOKUP [D2] IN TABLE-5 [E5] TO GET
VALUES FOR [E2],[E3],[E4]
STEP-5 CREATE REPORT FOR VALUES [E2],[E3],[E4]

I am neophyte when it comes to using advanced queries
code and will need things explain in idiot form..lol
I really appreciate any help that is giving..
 
Hi,


Make a new query, bring all tables. When you say "lookup" , drag and
drop the field from the initial table over the looked into field (drag and
drop in the upper half portion of the designer). When those JOIN are made,
in fact, inner joins, just bring in the grid the field you need for the
report. Save that query, use it to build your report.

That's all.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top