Complicated Cross Tab

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi

I had a question about a very complicated cross-tab. The client wants a
matrix of values that has one variable for the columns, and 25
different ones for the rows.

First, is this possible? The wizard only allows me a couple of
variables for rows. I'd love to see an example, especially when it
involves counting occurences across multiple child records for a parent
and with perhaps a date range included for reporting purposes.

Thanks

Jeff
 
I, for one, am going to need more information as to exactly what is
required. Please give a few examples of the row "variables", and tell us
what the value is going to be.
 
You should be able to place many more fields into Row Headings. Finish the
wizard and go to the design view of the query and add more.
 
Hi David

The database is for a social services agency. The crosstab query uses a
parent record and a few children records. The parent record is for the
patient and each visit is an occurence of one type of child record. If
the patient withdraws from the program, that becomes another child
record. Each child of the patient is another child record.

The columns are the social workers (by name). The rows include are all
counts of occurences, and include things like neighborhood (which I
have done), but they also want to report:

# of children
# withdrawn for a particular drop down value
# of visits

etc

Does that help?

Jeff
 
Back
Top