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

update text values 1

Status
Not open for further replies.
ciarra41

ciarra41

Technical User
Sep 11, 2006
116
US
I'm trying to remove 0:00:00 from a text field using left, right, mid or a substr function in a query

Old:
4/01/2007 0:00:00
11/01/2007 0:00:00

New:
4/01/2007
11/01/2007
 
Sort by date Sort by votes

How about
[blue]FieldName = Left(FieldName, Len(FieldName) - 8)[/blue]

Randy
 
Upvote 0 Downvote
I got it
Left([Fiedlname],InStr([Fiedlname]," ")-1)


by yours workded too-thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
399
dhookom
dhookom
MattGreer
  • Locked
  • Question
Can't update a field from a query result due to 'Group By'
Replies
2
Views
220
dhookom
dhookom
teach314
  • Locked
  • Question
Finding records that have no values in common 1
Replies
2
Views
218
teach314
teach314
TheresAlwaysAWay
  • Locked
  • Question
Using Domain Aggregate expression in Update Query 2
Replies
12
Views
416
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top