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

Convert Text to numeric

Status
Not open for further replies.
maha12

maha12

Programmer
Sep 8, 2002
79
LK
Hi

I am using VB6 and Access 2000 database.

I want to get max number of a text field(PONo). So how do I convert this text field(PONo) to numeric and get max of the text field in SQL language.

Tks
Maha
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
320
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
871
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
203
Andrzejek
Andrzejek
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
356
marty1944
marty1944
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
211
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top