Trying to avoid SUBs

[teqtaq]

Hi!
I have a table with data like this:

NAME ID FT/PT STATUS AVAIL

AAA 10 F E 1
AAA 11 F R 2
AAA 12 P E 1
AAA 13 F E 3
AAA 14 P R 2
AAA 15 P C 1
AAA 16 F C 1

I need to show on my Report:

NAME NON-C C
Status_E Status_R FT PT
AAA countAVAIL countAVAIL countAVAIL countAVAIL


Is this possible to do without SUBs?

Thanks


AAA 1

 

[teqtaq]

I went with union query. But I would like to see your opinions.thanks

 

[dhookom]

You haven't provided the values you would expect in your display. Your headings don't line up so it is difficult to see what you want output.

If I understand correctly, I would use a totals query with expression like:
C_FT_AVAIL: Sum(Abs(Status= "C" AND FT_PT="F" ) * [AVAIL])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]