Getting totals
Hi
I use php/mysql to record the number of people visiting a clinic.
I have used the Data Assist Search Wizard to extract/view data and that all works fine. (The record set I am extracting it from is quite complicated and links 5 tables.)
What I would now like to do is total up the number of results. Normally I would use something like Count(counter) / Group By counter to get results but it just gives the total number of records rather than the search results.
Can I get the search criteria to apply to two record sets or is there another way of doing it?
Many thanks