Using Ms Access simple joining giving me repeated data

Question

(i want distinct in msaccess query) i have two tables where my data is matching and repeating in datagridview im working on report plz help me

here is my simple join query

select Labortary.Test_Name,Labortary.Test_Charges,LabortaryTestRecord.[Total Amount] 
from LabortaryTestRecord,Labortary
where LabortaryTestRecord.[PatientID]=Labortary.Patient_id
and LabortaryTestRecord.[PatientID]=34

Have you tried adding the `DISTINCT` keyword to your query? http://stackoverflow.com/questions/5788586/how-to-use-distinct-in-ms-access — CJBS, Oct 14 '14 at 05:43

score 0 · Accepted Answer · answered Oct 14 '14 at 06:16

0

You must add DISTINCT keyword:

SELECT DISTINCT Labortary.Test_Name,Labortary.Test_Charges,
 LabortaryTestRecord.[Total Amount] 
FROM LabortaryTestRecord,Labortary
WHERE LabortaryTestRecord.[PatientID]=Labortary.Patient_id
   and LabortaryTestRecord.[PatientID]=34

answered Oct 14 '14 at 06:16

Ivan Cachicatari

4,212
2
21
41

yes thanks i solved my problem writing distinct key word – Sheeraz Bughio Oct 14 '14 at 07:21

Using Ms Access simple joining giving me repeated data

1 Answers1