|
mousemee
Starting Member
Singapore
1 Posts |
 Posted - 03/16/2013 : 00:43:32
|
Hi, i am currently practicing sql using access vba.
i created a statement
SELECT APPTLOOKUPTABLE.APPT
FROM APPTLOOKUPTABLE
WHERE (((APPTLOOKUPTABLE.DEPT) Like [DEPTCB].[Value]))
IT WORKED WHEN I TRIED IT AS AN SQL QUERY, SHOWING ME A LIST OF APPOINTMENTS WITHIN MY TABLE.
HOWEVER, WHEN I INSETED IT INTO VB ACCESS, IT ONLY RETURNED A SINGLE VALUE, WHICH IS THE FIRST VALUE WITHIN THE TABLE THAT IS EQIALS TO DEPTCB.VALUE
WHEN I ADDED THE KEYWORD DISTINCT, HOWEVER, IT WORKED PERFECTLY FINE. I DO NOT UNDERSTAND HOW THIS COULD BE.
ANY HELP IS APPRECIATED. |
|
sql query
