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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JeffreyLSmith
-
Formatting SQL SELECT using SUMs returns an error
Thanks for the info Antzz... I have a second question relative to the SUM function. Is the resulting field as described by the AS parameter a summation of all the records in the SUM(FIELD) field? Hope this makes sense... Thanks.- JeffreyLSmith
- Post #3
- Forum: Visual Basic (Classic)
-
Formatting SQL SELECT using SUMs returns an error
I've added several sum functions to the query string which is "ok" per the Data Env. designer, but VB returns an error upon execution. The error appears to be within a previously working section of the query, ala before the sum functions were added. Here is the query: "SELECT...- JeffreyLSmith
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
