query is acting up

[kwooten]

I am rather new with Access and everything I know I have taught myself or learned here.

[June7]

I see no reason for the GROUP BY qualifier.

You can keep the INNER join which excludes the records without recruiter or use LEFT or RIGHT join and apply a filter criteria to the Recruiter field to exclude records where Recruiter Is Null.

[kwooten]

So even if I write an IIF statement, I dont have to make it an "expression"??

[June7]

If not a GROUP BY. Expressions are creating a field in query. They can be referred to by other queries just as any 'natural' field.

[kwooten]

i didnt know that.. however, i think i tried this route and the formula in my report wouldnt work.. ill try again..

[June7]

What is happening in the report is another issue. You can use a regular SELECT query as the report RecordSource and then use report Grouping and Sorting with aggregate calcs to show detail records as well as summary data.