Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Do I have the proper syntax on this SQL statement?

Status
Not open for further replies.
elvenmaiden

elvenmaiden

Programmer
Apr 25, 2002
31
US
I am tring to connect to an Access qry through VB using SQL, but I am getting an overflow error. Any suggestions??

Set rsStats = conHelpPlus.Execute("SELECT qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions, SUM(qryStats.Accepted/qryStats.Solutions) as AcceptanceRate from qryStats WHERE qryStats.UserEmail = '" + mstrUser + "' GROUP BY qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions")

Thanks
 
Sort by date Sort by votes
Received answer in the VB 6.0 forum - please disregard
Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
182
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
199
szeiss
szeiss
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
193
mmiah1982
mmiah1982

Part and Inventory Search

Sponsor

Back
Top