subqueries

T

tom

Does Access allow subqueries?

Anyway I have a simple problem. I have a bills
table and a supplier table and I only want the info to show up in column of
the query if the supplier has certain criteria. For the rest of the
columns in the query
I want to use info for all the suppliers with no conditional
on type of supplier.
 
P

punjab_tom

nope; no subqueries in Access

just use SQL Server; Access Data Projects are _EASIER_ to use than
this .MDB _CRAP_

I mean seriously

'linked table manager' this and 'frontend backend' that

don't listen to these blue-hairs just use ADP
 
S

Smartin

tom said:
Does Access allow subqueries?

Anyway I have a simple problem. I have a bills
table and a supplier table and I only want the info to show up in column of
the query if the supplier has certain criteria. For the rest of the
columns in the query
I want to use info for all the suppliers with no conditional
on type of supplier.

Yes subqueries are allowed, but you may not need them here.

For the conditional column you might be able to use an IIf statement to
check the conditions and return values appropriately.

SELECT
IIf (<conditions to test>, <value if pass>, <value if fail>),
<other columns constrained by WHERE clause>
FROM
MyTable
WHERE
<global conditions>
;
 

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

Top