Cross Tab Queries

[Nixx1401]

I created a crosstab query which I am trying to use to generate a report or form but the wizard is displaying any fields to be selected from the query.



This is the query

Field StrMailType
Table tblTransaction
Total Group by
Crosstab Row Heading

Field StrProcess
Table tblTransaction
Total Group by
Crosstab Column Heading

Field StrTransNo
Table tblTransaction
Total Count
Crosstab Value

Field DteDate
Table tblTransaction
Total Where
Criteria Between [Beginning Date] and [Ending Date]

Field StrProcess
Table tblTransaction
Total Where
Criteria "In"

I declared the criteria date in parameter in the query window and the query ran fine. It is I am unable to use it in a report or form.

[llkhoutx]

Your form, with a crostable query record source, will have multiple records. Use a continuous form, with fields on one row.

Your report, with a crosstab query record source, will similarily have a detail section with one row.

A crosstab query displays multiple rows, treat your form and report accordingly.

[Nixx1401]

I created a crosstab query which I am trying to use to generate a report or form but the wizard is not displaying any fields to be selected from the query.

Not was left out of the introduction to the problems quoted above. Would your response still apply? If so can you elaborate some more dont quite understand.

[llkhoutx]

If the something you try to do with a wizard isn't doing what you think it should, try something else. Access is very forgiving.

Manually build the report.

[Nixx1401]

The query now runs in design grid but when i try to build the report manually using the query it prompts for the beginning date and ending date and this prompts constantly repeats. Can you offer another way to accomplish this task. I have a transaction table which have the following fields: TransNo, TransDate, MailType, Process, VisitorNo, ChildNo. I would like to generate the total number of Process for each mail type with in a given date. The mailtypes are Letter, Visits, Postcards. The processes are In and Out.

[llkhoutx]

It prompts for the dates because the prompt is probably in the query.

Store the start and stop dates in (maybe hidden) controls on a form and then reference those controls appropriately in your report.

[Nixx1401]

ok thank you