It sound like a simple task to perform but I just can't seem to get it. I've built a search function on the site and after each search request, a log is kept of the search word and the date, so the table looks a little like this:
I've tried to expand on the query in another area of the site but running into a few problems,
- tblSections (ID, Name, Description)
- tblSectionsLog (ID, SectionID, DateVisited)
tblSectionsLog is identical to the table in the above post, but it holds a row for each time a section of the site has been visited. but as well as counting how many times a section has been visited, I need to pull out it's Name and Description.