Help w/query that includes user-defined field

[sparkly]

Can someone please help me with a query? I’m trying to pull a report of patient info, like name, address , etc but I need to include values from a specific USER-DEFINED Patient Field. How would that be written? (Patfielddef and fieldname in there somewhere?)
Thanks!

[sparkly]

can anyone give me the values so i can plug them into my query??
thanks!

[Jorgebon]

The patfield table contains all the info you need to add to the patient table for the report you want. The fields that you may need are patfield.FieldName, patfield.FieldValue and you can use patfield.PatNum as a link to the patient table. If you have more than one patient field defined, then you will need patfield.PatFieldNum.
Jorge Bonilla, DMD

[sparkly]

thanks, that's the missing link for me to try to cobble this thing together. as always, thanks jorge!!!!!!!!!!!