Crosstab Queries or maybe something else

  • Thread starter Thread starter taft71
  • Start date Start date
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?
 
Back
Top