Advanced Query of Simple Query Results

Advanced Query of Simple Query Results

  
I have created a simple query that allows users to filter results. I want to know how you can make an advanced query on the record list created by the simple query. What is the right way to do this? I created the simple query now I want to put a few expression boxes in the records table that does a distinct count on different columns.
Ken
Is it even possible to do an advanced query on a record list from another simple query?
Hi Ken.

To do a distinct count you must use an Advanced Query only. You cannot apply an advanced query to the result of a simple one.


Regards,
João
Ok, thanks for the reply. That was what I needed to know. I thought it might be possible to query a record list from another query.