query using specific table

[awake2424]

Hello,

Is it possible to have a query that uses criteria to pull data from a specific table?

For example: IIf([Result]'"Negative",(tblNegative goes here),IIf([Result]="Positive",(tblPositive goes here].

The tables are just text, but the query would be too long if it was used.

Thank you.

 

[spikepl]

Is it possible to have a query that uses criteria to pull data from a specific table?

That is what 99% of queries do for a living.

I have reread your post a number of times but still do not understand what you want. Can you rephrase or give a specific example?

 

[awake2424]

Tblnegative:
"The reulsts are negative indicating ..."
TblPositive
"The resuls are positive indicating .."

Is there a query that can pull the table based on a field in a form (Result)?

So if result is negative the query pulls tblnegative

If result is positive the query pulls tblpositive. Thank you.