Search results

Thanks Is a crosstab query better?

Now I"m getting this error: the select argument includes a reserved word or an argument that is misspelled/missing or the punctuation is incorrect So here is my sql, does anything jump out? I've been staring at it for 20 minutes SELECT test.patientid, "PrePregMed" AS PrePregMed...

Wow, okay, neat. I have never queried a query before. I made a dummy version to play around with and this works. Thanks so much, I would've never figured this out on my own :)

okay so I think im understanding crosstab a little i will post when i get the actual db in front of me but the GROUPBY function makes me nervous. should i just select MIN? does this matter? is it going to alter the output? i can't seem to do it with more than one dataset in the query grid...

actually let me redo this visitid, patientid, visittype, data1, data2,... 1, 1, 1, 1, 2 2, 1, 2, 77, 1 3, 1, 3(rdTrimester), 1, 1 4, 2, 1(stTrimester), 1, 2

alright I need to look up what a crosstab query is. i did not design this database myself and i cannot get access to it at the moment so bare with me :o most of the data is MedicationType (1 for yes and 2 for no 77 null) so the visitTypes don't repeat for each Patientid, if that makes sense..

Re: newbie needs help, what is thsi called wow, thanks! :) question tho, there's like 10 different fields so itll be more like PATIENTID | 1st Trimester | data1 | data2... data10 | 2nd Trimester | data1 | data2...data10 so for each data. i guess i should say field, i'd have to use a...

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...