Update Query/Converting

Dear all,


i have searched /researched and looked at hundreds of posts, and no luck.

Im litlle bit out of my depth, i have posted this before but just got confused.

i have two update querys, the first one identifys if a persons age (by date of birth) is under 16 a check box identifys if this person is "ticked" as junior.

the second update query identifys by (date of birth) if the person is over 16 a check box identifys if this person is "ticked" as senior.

The results are returned into my main query in two columns, these columns return -1 or 0 for junior or senior.

I need to produce a report that returns J or S (Junior or Senior) is there a way of converting these results to one column and converting the -1, 0 to J or S.

Please see attached file.

very lost, still searching for the answer. been on this foe three weeks now.

any help appricated.