Crosstab Queries or maybe something else

T

taft71

I am trying to generate a summary report, with Completedate,mmyyyy as the
column field and as the row field Submitarea and BSA Action. For
instance:
SubmitArea BSAAction 10/05 11/05 12/05
SubmitArea1 BSAAction1 1 0 2
etc

The problem I have is that I cant figure out how to generate the column
months since they dont exist yet. It would be alright if the crosstab
would automatically update with the next month, but I cant see how that
works.

Any help here?
 
Top