xtab query

[Guest]

I'm attempting to create my school's master schedule from a download. Importing data into a table and then running a xtab query (teacher - column)(period - row) works perfectly. To make the final product more appealing - I have created a report - the data source is the xtab query. I was doing great until I wanted to add more than one field in the detail area; I have no problem getting the subect title into the detail but i want to put the subject number/room number/class size into the detail as well. i've been working on this problem for more than a week now (a long time for this newbie) and can't find an answer - so can anyone help me?

 

[Marc]

I'm attempting to create my school's master schedule from a download.

Importing data into a table and then running a xtab query (teacher -
column)(period - row) works perfectly. To make the final product more
appealing - I have created a report - the data source is the xtab query. I
was doing great until I wanted to add more than one field in the detail
area; I have no problem getting the subect title into the detail but i want
to put the subject number/room number/class size into the detail as well.
i've been working on this problem for more than a week now (a long time for
this newbie) and can't find an answer - so can anyone help me?

Hi,
I think you'll have to trick it - make a query giving all your fields you
already need for the successful query. Then in the query builder column for
the subject title - click on the wand and type

Details: subjectTitle & " " & subjectNumber & " " & roomNumber ... etc
HTH
Marc

 

[Guest]

marc - thank you very much for your reply. your suggestion is exactly what I am trying to do, but i haven't been able to get each filed ( subjectname, subjectnumber, room, size) to remain in a fixed location in the detail cell. i know that this is caused by the variable length of the subjectname (all other fields are a fixed length) and i want to the subject name to be at the top of the cell - only because that is the way administrators and teachers are used to seeing the table. do you know of a way that i can "fix" the subjectname field (ie and include spaces) once i have everything falling in the same place all the time i can the n go on to work with the size of the detail cell. in my table it is text and the size is 20.

 

[Marc]

Hi,
Getting them in fixed places will be difficult if not a useless struggle.
You can try & vbcrlf & to force when a new line will be printed. Unless you
are using a non-proportional font such as courier new trying to predict
where characters will end up is a black art.
Sorry I can't be more encouraging.
Marc

marc - thank you very much for your reply. your suggestion is exactly

what I am trying to do, but i haven't been able to get each filed (
subjectname, subjectnumber, room, size) to remain in a fixed location in the
detail cell. i know that this is caused by the variable length of the
subjectname (all other fields are a fixed length) and i want to the subject
name to be at the top of the cell - only because that is the way
administrators and teachers are used to seeing the table. do you know of a
way that i can "fix" the subjectname field (ie and include spaces) once i
have everything falling in the same place all the time i can the n go on to
work with the size of the detail cell. in my table it is text and the size
is 20.

 

[Duane Hookom]

You might want to check out the crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP

marc - thank you very much for your reply. your suggestion is exactly

what I am trying to do, but i haven't been able to get each filed (
subjectname, subjectnumber, room, size) to remain in a fixed location in the
detail cell. i know that this is caused by the variable length of the
subjectname (all other fields are a fixed length) and i want to the subject
name to be at the top of the cell - only because that is the way
administrators and teachers are used to seeing the table. do you know of a
way that i can "fix" the subjectname field (ie and include spaces) once i
have everything falling in the same place all the time i can the n go on to
work with the size of the detail cell. in my table it is text and the size
is 20.