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!

build an expression

Status
Not open for further replies.
senia97

senia97

Technical User
Jul 26, 2005
4
US
I am trying to create a query from a feild containing numbers and text. The feild contains this for example (ex:123456-Indirect) I need to use an expression to gather just the six numbers on the left in the feild. Please help me.
 
Sort by date Sort by votes
Use the Val function:
SomeName: Val([field name])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
827
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
animation waiting
Replies
0
Views
389
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
732
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top