eri
02-21-2012, 07:37 AM
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.
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.