J
JohnLute
My concatenation code is returning:
"Invalid SQL statement. Expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
Can anyone see the problem in my code?
Drums: Concatenate("SELECT ProfilesAssociations
FROM tblPKProfilesAssociations
WHERE txtProfileID =""" & [tblProfiles.txtProfileID] &
[tblFGAttributes.Status]="Drum" & """ ORDER BY ProfilesAssociations")
Thanks!
"Invalid SQL statement. Expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
Can anyone see the problem in my code?
Drums: Concatenate("SELECT ProfilesAssociations
FROM tblPKProfilesAssociations
WHERE txtProfileID =""" & [tblProfiles.txtProfileID] &
[tblFGAttributes.Status]="Drum" & """ ORDER BY ProfilesAssociations")
Thanks!