Recent content by jol

I got it to work with this SQL: PARAMETERS [start date] DateTime, [end date] DateTime; TRANSFORM Count([Contact Tracker].ID) AS CountOfID SELECT [Contact Tracker].[Contact Name] FROM [Contact Tracker] WHERE ((([Contact Tracker].[Date of Contact]) Between [start date] And [end date])) GROUP BY...

I appreciate your attempt to help. I don't know where a GUID would be needed either. My table is quite simple.

Thanks. When I tried this, I get the error: Malformed GUID in query expression '[Date of Contact] Between [EnterStartDate] and [EnterEndDate]'.

Thanks for the welcome! I'm happy to have this resource. I've tried it multiple different ways and have gotten a multitude of errors. If I try to add the HAVING statement above after the GROUP BY, it says "Syntax Error in TRANSFORM statement." If I try adding between [EnterStartDate] and...

I want to be able to run a query that provides the results for a specific date range. I've been able to do this for a simple query using: SELECT [Contact Tracker].[Date of Contact], [Contact Tracker].[Type of Contact], [Contact Tracker].[Contact Name] FROM [Contact Tracker] GROUP BY [Contact...