W
Walter Steadman
I have a query that lists all the pilots in the unit and all the hours they
have flown. One of the fields in the Query is called firstSemi and it is a
Yes/No checkbox. one of the other fields in the query is Hours. Is it
possible in the report to put an unbound textbox and do something like
if([firstsemi] = true then Sum(hours))? I know I should do this in the
query portion, but trying to find out if it is possible in the report
section. That way I can put two unbound textboxes and one will give me the
sum for when the firstsemi checkbox is true and one will give me the total
of hours if the check is false. Don't know how to make it work in a query
because in a query it does not include all pilots at all times. If a pilot
has no checkmarks as true then he/she is not included in the query results
so therefore won't be in teh report results either.
Thanks in advance for any assistance
Wally Steadman
US Army, Iraq
have flown. One of the fields in the Query is called firstSemi and it is a
Yes/No checkbox. one of the other fields in the query is Hours. Is it
possible in the report to put an unbound textbox and do something like
if([firstsemi] = true then Sum(hours))? I know I should do this in the
query portion, but trying to find out if it is possible in the report
section. That way I can put two unbound textboxes and one will give me the
sum for when the firstsemi checkbox is true and one will give me the total
of hours if the check is false. Don't know how to make it work in a query
because in a query it does not include all pilots at all times. If a pilot
has no checkmarks as true then he/she is not included in the query results
so therefore won't be in teh report results either.
Thanks in advance for any assistance
Wally Steadman
US Army, Iraq