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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Query 2
Crosstab Sort Order 4
Extracting from Crosstab query 2
Crosstab query date sort 1
Crosstab Query Header Fields (?) 3
Crosstab query Date Span 7
Help on crosstab query 2
Crosstab Query Column headings 4

Back
Top