I have a table that contains ALL TEXT fields. All my counting comes from counting text fields. Example:
[last name],[first name],[rate],[rank],[officer/enlisted],[job pos],[gender],[UIC 1190 or 2253],and [remarks].. get the hint. Note: I filter on the remark section a lot get other information on personnel that are assigned to special, schools, other commands, special projects, and so on...
Now for the Problem! My end-users want a report that counts all for these things, in all type of combinations thats not to much of a problem. The problem is I want to able to add up to totals from two or three different queries in my report.
Example: I have three queries already that counts number of officers in UIC 1190, all personnel in c-1 school and all enlisted personnel in 2210... Now how can I add the totals from three different queries in my report?
[last name],[first name],[rate],[rank],[officer/enlisted],[job pos],[gender],[UIC 1190 or 2253],and [remarks].. get the hint. Note: I filter on the remark section a lot get other information on personnel that are assigned to special, schools, other commands, special projects, and so on...
Now for the Problem! My end-users want a report that counts all for these things, in all type of combinations thats not to much of a problem. The problem is I want to able to add up to totals from two or three different queries in my report.
Example: I have three queries already that counts number of officers in UIC 1190, all personnel in c-1 school and all enlisted personnel in 2210... Now how can I add the totals from three different queries in my report?
