patkeaveney
Registered User.
- Local time
- Today, 08:23
- Joined
- Oct 12, 2005
- Messages
- 75
The SQL below is taken stright from the SQL view of the query.
When trying to use it as an SQL statement I get the above error:
Set rs = CurrentDb.OpenRecordset(SQL_String)
SQL_String = "SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM qrySearchByExemption]. AS RecCount;"
The query runs fine in access
I am trying to use the value "count" from the query to use in a mesage box on a form
Any help greatly appriciated.
Pat
When trying to use it as an SQL statement I get the above error:
Set rs = CurrentDb.OpenRecordset(SQL_String)
SQL_String = "SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM qrySearchByExemption]. AS RecCount;"
The query runs fine in access
I am trying to use the value "count" from the query to use in a mesage box on a form
Any help greatly appriciated.
Pat