Crosstab Query

[jones]

Hi Everyone,

Please help me my Crosstab query problem.

I make a manpower table and attendance table with name, date, project code and a check box, then i make a append query so that whatever put in a manpower table with corresponding check box, it append in attendance table.



Then i make a crosstab query so that the data will arrange according to date.

My problem is i can't find the solution of the crosstab value if the a check box has a checked = 1 and if check box is unchecked = 0 so that when i make a total in every date, i could easily know how many people are in the project.


As you can see in the attached, i use only the average but the result is -1 and 0.

Now, im still searching of my two problem:

1. the -1 value
2. how to put the sum in crosstab query.

Advance Thanks in a million.

[June7]

Try Count instead of Avg.

[jones]

Thank you for your suggestion but i try that already and the result is not what i expected bcoz it also count the uncheck as 1,
what i want is the check box if is checked then = 1, and if it is uncheck it should be 0.

Thank you very much.

[June7]

Instead of the Attendance field as the crosstab Value, try this calculated field: Count(IIf([Attendance]=-1,1))

Select Expression on the Total row.

It works with the sample data you posted.

[jones]

Thank you very much Sir, I will try it.