Page 1 of 1

Adding additional limitations existing query

PostPosted: Wed Oct 19, 2011 9:25 am
by datadon
What I am really asking is, let's say I have a current query in display, it is not all the records. Is there any way to run another query on top of that one other than to have to rewrite the query with an "And" and tie the two together, both the first and second? Maybe something in an SQL statement?

It can be done saving the original string and then adding to it, but was wondering if there is something else that might work.


Thanks

PostPosted: Wed Oct 19, 2011 11:00 am
by smartmedia
Hi..

Normally in SQL you can execute 1 or more queries in a single on. A SELECT inside a SELECT, i am not sure if is working over Access. Check here for syntax.

http://dev.mysql.com/tech-resources/articles/subqueries_part_1.html