combining groups in a query for a report

[Guest]

I have a database for work with the following problem

Query Design:
Crew Position Total Flights Total SNP Total NEO
Group by Sum Sum Sum

This works as above as it totals each crew position combined and gives me a
total

My problem is when I add a grad date(group by) and then search for a start
date and end date as such using "Between [start date] And [end date] when I
re-run this query it gives me a separate line for each crew position instead
of combining all the numbers for a total

 

[Duane Hookom]

Share your SQL. I expect you need to set a Totals to Where rather than Group
By.

 

[Guest]

Thank, Change to "Where" and it works like a champ - you rock!!

Mike

Share your SQL. I expect you need to set a Totals to Where rather than Group
By.

--
Duane Hookom
MS Access MVP
--

I have a database for work with the following problem

Query Design:
Crew Position Total Flights Total SNP Total NEO
Group by Sum Sum Sum

This works as above as it totals each crew position combined and gives me
a
total

My problem is when I add a grad date(group by) and then search for a start
date and end date as such using "Between [start date] And [end date] when
I
re-run this query it gives me a separate line for each crew position
instead
of combining all the numbers for a total