I have found using simple queries in Access, then using a final query to pull the data together the only way to solve some problems. But how can this be represented in SQL for outside access?
the SQL Access shows wont work, because the simple queries take parameters themselves.
looks like a classic sql subquery to me, but i cant get access sql to use such a construction.
if you're still reading, the main use is to extract a stock list name of all parts of a certain type, then join this to another query which describes levels, but LEAVES BLANK the parts name lines which have no level. i have not succeeded in convincing Access to do this, ever in one query. :-(
the SQL Access shows wont work, because the simple queries take parameters themselves.
looks like a classic sql subquery to me, but i cant get access sql to use such a construction.
if you're still reading, the main use is to extract a stock list name of all parts of a certain type, then join this to another query which describes levels, but LEAVES BLANK the parts name lines which have no level. i have not succeeded in convincing Access to do this, ever in one query. :-(