We help IT Professionals succeed at work.

SQL with access 97 mdb

lgc5800
lgc5800 asked
on
264 Views
Last Modified: 2010-04-05
Hi,
I use Delphi 5 with a Access 97 mdb and ADO.
In the delphi adoquery1 sql editor i want to do this :

SELECT agv(table1.pourcent)....
FROM ...

But table1.pourcent is a string.
How to convert to int ?

SELECT avg(cint(table1.pourcent)) dont work
also dont work : stringtostr, string_to_str...

Where i can find a document where all the function are detailled ?


Thanks.

Comment
Watch Question

Top Expert 2004
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
table1 is a table in the access mdb
Top Expert 2004
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.