Crosstab query for multiple dates

  • Thread starter Thread starter lsyrkin
  • Start date Start date
L

lsyrkin

I have a table with following fields: PatientName;DateOfVisit;Weight
I need to create a crosstab query with PatientName as Raw Heading,
DateOfVisit as Column Heading and Weight as Value. This approach is
not working for me as too many dates exist. I need to convert dates
into some kind of VisitNumber or Occurance, etc. Say, if a patient had
5 different DateOfVisit, I would like to transform these Dates into
Visit1, Visit2, etc. I will appreciate any help in this matter.

Leonid
 
I found another posting (listed below) that should help
After running the query to produce the Rank field you can use the rank field
in the crosstab


That does the trick : ) Thank you VERY much!!
 
Back
Top