help123
Last Activity: Mar 22 '12, 10:10 PM
Joined: Feb 15 '12
Location:
-
I did use the new query as the source, but the crosstab query still tells me it is not okay and I get a message that (although the query for the crosstab data is new,the source of THAT query) includes an alias. What does it mean to use the "derivation "? I do not know how to include these alias sql in the crosstab query itself. -
Thanks. Sorry, but I am not clear how to proceed. I did the ranking by using sql alias tables. I normalized the data structure with union commands. It's the pivot on this data that is the problem since the sql command for pivot (crosstab) do not allow data that had used the alias. Is there vba code to address this problem? (I am very new to Access so not sure how to write code for this.)
Is there a way to send you my database to show...Leave a comment:
-
The tblLabResults has data as
PatientID LabDate TotChol Trig.... (20 lab measures)
1 1/12/99 14
1 2/15/00
2
2
2
2
The report must include the first lab visit and the last four lab visits, with a "lab visit number" below the date:
The columns are supposed to be:
Patient ID Measure Lab#1 date 4th most recent lab date 3rd most...Leave a comment:
-
Crosstab Query with Variables Created using Alias
Dear online Access wizards, I have been reading posts for days and remain utterly baffled. I am trying to create a database for a clinic. The MD's need a report with all lab results for a given patient's first and last four visits. They want the lab measures (eg cholesterol, trig, etc) as rows and the lab dates as columns.
The only way I could think of to limit the results to the first and last four lab visits was to create queries...
No activity results to display
Leave a comment: