subqueries

[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.

 

[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

 

[Smartin]

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>
;