Search results

Combining 3 Queries with "count" in them This is what I've tried: SELECT Count(Event.EventNumber) AS CountOfEventNumber, [All Tracking Information].EventNumber FROM Event INNER JOIN [All Tracking Information] ON Event.EventNumber = [All Tracking Information].EventNumber GROUP BY [All Tracking...

I have the following queries with these fields (which the queries on their own work great): qryEvent CountOfEventNumber EventDescription qrySite CountOfSiteNumber SiteDescription qryTopic CountOfTopicNumber TopicDescription How can I link these in one query so that the counts only come...

Thank you, I will give it a try. If it doesn't work I'm sure you will be reading me again. Thanks,

Pat, Thanks for the reply but I have 6 different reports that use that prompt. If I put a run button on the prompt form it will only open the one form, I'm sorry if I nieve, but how would you do this to be able to run each report from the same prompt and button. Thanks,

Hi, I have a report that when you open it, it will ask for a date range (start date and end date) and person's name, these work fine. You enter the dates, the persons name, and the report pops up. I want to be able to close the report and have the date prompt/name prompt there to enter new...