V
Valix
I have a table where i keep mission information. i am trying to build a
query to pull the date (for date specific info), the type of aircraft, and
the number of inbound and outbound mission numbers. I run a simple query
GROUPED BY date and type aircraft and COUNT both inbound and outbound mission
numbers. my problem is this:
lets say on 1 July i had 2 inbounds and 3 outbounds of this aircraft. when
i run the query i need to see 2 and 3 for that date. but i get 5 and 5. ive
tried critria Is Not Null and that changes nothing. What else can i do to
get it to not count the blanks?
query to pull the date (for date specific info), the type of aircraft, and
the number of inbound and outbound mission numbers. I run a simple query
GROUPED BY date and type aircraft and COUNT both inbound and outbound mission
numbers. my problem is this:
lets say on 1 July i had 2 inbounds and 3 outbounds of this aircraft. when
i run the query i need to see 2 and 3 for that date. but i get 5 and 5. ive
tried critria Is Not Null and that changes nothing. What else can i do to
get it to not count the blanks?