Sql Query

[dexter2003]

can anyone help me retrieve this...

the field..

patient id , datepn , diagnosis , progress notes

from the table [progress notes]



the field...

name, maiden name, surname, age , sex


from the table [ patient personal information]


suppose i entered in the textbox is 2. i want to query my database to show only patient with patient id number 2.

i'll be using this on my data report w/o data environment, im stucked... coz im having an error, and they told me that i must have a grouped recordset...


Pls.. help.

[lintz]

Try this....

Dim ProgressNote As String
Dim sSQL As String

ProgressNote = Text1
sSQL = "SELECT tablename.patient id AS ID, tablename.datepn AS Date, tablename.diagnosis AS Diag, tablename.progress notes AS Note from tablename WHERE tablename.progress notes = 'Progress Note'"

Repeat the above for your 2nd query.

HTH

[dexter2003]

i tried that but im still having problem with my datareport...

http://www.vbforums.com/showthread.p...hreadid=259972


check that out...