newbie needs help

[hollyh]

i am not sure how to describe this so bare with me

basically i have a VISIT TABLE
with

VisitID
PatientID
VisitType (1st Trimester, 2ndTrimester, etc)
and then columns pertaining to the visit

We are trying to do a longitudinal study where we compare each visit type data to itself to be exported to excel so it would look like this all in one column based on patientID



PATIENTID | 1st Trimester | data | 2nd Trimester | data |

is there a way to query this so the visit types and data are all in the same row based on patient id

[dreday]

You need to do a crosstab query where the row heading is [Patient ID] & " | ", the column heading is [VisitType], and the value is [VisitType] & " | " & [Data] & " | ". From there a 2nd query can be used to combine all the fields using &.

Hope this helps