M
mikcin
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
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