"An action query cannot be used as a row source"

[jal]

See attached query.

The inner SELECT works fine as a standalone query, but when wrapped in the outer SELECT, I get the error "An action query cannot be used as a row source."

I'm running this query on an MDB file from C#.Net, but I get the same results if I copy and paste it into Access 2003 SQL view - there too the inner SELECT works fine, but doesn't work when I wrap it in the outer select. I've also tried removing the final WHERE clause (i.e. the outer WHERE clause) but in all cases, I get the same error message every time I use an outer SELECT.

 

[boblarson]

You cannot have a query that has INTO (make table) as a row source. You can create the table and use that table as a row source but you can't use the action query where you would use a select.

 

[jal]

You cannot have a query that has INTO (make table) as a row source. You can create the table and use that table as a row source but you can't use the action query where you would use a select.

Thanks Bob, I feel a little silly about missing that. For me, that's par for the course though.

 

[boblarson]

Eh, no problem. I think I've had way beyond my fair share of doing something like that. I guess that is why I can identify some of those things quickly - lots of FIRSTHAND experience.