tried to execute a query that does not include the specified expression error message

[chriswrcg]

I am building some reports in my data base and have been having some good success. My coaching report is working perfectly - exactly like I want it to.

I tried creating another report similar to the coaching report and am getting the an error message. The only thing different with the two queries that link to the reports is the second one (the qryweeklyReport) the majority of fields have been grouped. In the full name field I have the following criteria in place:

like"*" & [Name "last,first":] & "*"

. This brings up a window that lets me enter in the name of the associate I want to look at. I also have a

between [start date] and [end date]

criteria set up on dates.
What can I do to solve the problem?

[ranman256]

if thats the criteria you want , then its not a problem.
if you only want the date range, remove the 'like' criteria.

if you want 2 reports with different criteria
make Q1 pull all your records,
Q2 uses Q1 with the name range
Q3 uses Q1 with the date range

set your report to the proper Query.

[chriswrcg]

Got it figured out. The problem was that I had grouped the fields. I created another query based on the results of the first and applied my criteria . Everything works now.