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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Aggregation in SQL queries from VB to Action Request System

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Anyone got any ideas on how to use aggregate functions in SQL like COUNT, SUM and AVERAGE to query Action Request System tables from VB or MS Query?

I'm using VB 6.0 ADODB and can successful retrieve records but cannot use aggregation in the SELECT statement. For example (MS Query):

SELECT Count(XX_HelpDesk."Ticket No.") 'Countresult'
FROM XX_HelpDesk XX_HelpDesk
WHERE (XX_HelpDesk.Product='ORACLE')

returns error:
Expected lexical element not found <identifier>
 
Sort by date Sort by votes
Your syntax looks ok. The fact that you have quotes around the column with spaces is a good thing.

Have you tried aggregating on a different column...one that has a name with no spaces, just in case that's the problem?

If so, maybe your ODBC driver is outdated?
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

krzywica
  • Locked
  • Question
How to Hyperlink Remedy HDC's in Excel
Replies
0
Views
703
krzywica
krzywica
starrkg
  • Locked
  • Question
Remedy search query, average time to close?
Replies
0
Views
252
starrkg
starrkg
RifleSightNotch
  • Locked
  • Question
create a text file from multiple remedy fields
Replies
0
Views
720
RifleSightNotch
RifleSightNotch
heathercraw
  • Locked
  • Question
Adding License in AR System 5.x
Replies
0
Views
184
heathercraw
heathercraw
enbw
  • Locked
  • Question
Migration from ARS 6.3 to 7.1
Replies
6
Views
277
enbw
enbw

Part and Inventory Search

Sponsor

Back
Top