VBScript query using access union query

[JC-Access]

I have a large union query I would like to extract data out of, but I am not sure how I should format the query.
The name of the union query in access is "PH6-Combined-Dependencies"

Can I write a query to select records out of a union query in access?

Below is an example of a query similar to what I would like to use in the vbscript.

vbscript query:

Set QDF4 = cdb.CreateQueryDef(Tab4, "SELECT [Backup Properties].* FROM [Backup Properties]WHERE (([Backup Properties].Application)='" & strAppName & "')")

[ranman256]

Yes , you can query on queries.

[JC-Access]

Can you please give me an example of what that query would look like?

[June7]

Why are you using QueryDefs? Why do you need to programmatically create/modify query object?

Select from UNION query object same as from a table or other SELECT query.

Use Access query builder to help structure SQL statement then adapt for VBA.

[ranman256]

select * from qsMyQuery where [state]="NY"