SQL Strings

[mark curtis]

I am now ok at sending a single SQL string to access and returning the data to Excel BUT I now need to join three queries together in access to get the data I want.

The easy option is to just hard code the queries and call them in one SQL string but I would like to know how to string SQL strings together?

Thanks
Mark

 

[Len Boorman]

It depends.

The three SQL strings

are they just three data sets or

Is it a query querying a query querying a query.

Cos there can be problems with sub queries and I am not at all certain how many levels of subqueries are supported. Suggest you search Access Help on Sub Queries

L