Hi,

I have just started with programming in vba.
I'm not really sure where to put this question, so don't shoot me if i'm wrong
I need to make a table with the status in a form in access.
how can I do this?

X1 X2 #X3 #X4 #X5 #X6
XXX 1 36 24 9 2
XXX 2 29 24 5 0
XXX 3 24 12 10 0
Total 89 60 24 2


These information is stored in a database.
x1 contains txt values
x2 contains are priority's
X3 till x6 contains dates. I would like to see a count of these fields

I have tried playing around in crosstab but I cannot seem to find the solution.