473,396 Members | 1,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Update Query - search for "/"

Simple, I'm sure...

I'm trying to run an update query, where I am looking to update "/" with "-".

I can't figure out how to set the criteria/update to fields correctly for these special characters.
Apr 8 '10 #1

✓ answered by TheSmileyCoder

Thats the way dates are stored. What you want is do DISPLAY them differently.
Try:
format([JoinDate],"yyyy-mm-dd")


EDIT:
If you set the format property in the table itself, it will carry over to all new reports/forms.

5 1483
TheSmileyCoder
2,322 Expert Mod 2GB
Replace(strInput,"/","-")
Apr 8 '10 #2
table: tblMain
field: joinDate.

Trying to change the "/" to "-".
Dates are in 2010/04/01 format and I need them to be in 2010-04-01 format.
I was using the qry builder in access and trying to use the "Update" qry.
Apr 8 '10 #3
TheSmileyCoder
2,322 Expert Mod 2GB
Thats the way dates are stored. What you want is do DISPLAY them differently.
Try:
format([JoinDate],"yyyy-mm-dd")


EDIT:
If you set the format property in the table itself, it will carry over to all new reports/forms.
Apr 8 '10 #4
Yeah..I'm aware of that.
The thing is, I'm exporting this table into a CSV that is being imported into a *proprietary* system. They require this date format. The field is text, so it's not a true date format on either db.
Apr 8 '10 #5
Thanks for your help!
Apr 8 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Mark | last post by:
A beginner in this area, I have been able to read a record from a MySQL database and populate an HTML form (wow!). Now, my goal is to allow the user to edit the contents of the form and then...
3
by: Mike Cocker | last post by:
Hello, I'm quite weak at PHP, so I was hoping to get some help understanding the below code. First off, I'm trying to create a "query form" that will allow me to display the results on my...
2
by: hch | last post by:
dataAdapter.Update(data, "TableName") won’t work! I was about to deploy my first website on the Internet only to discover that the dataAdapter.Update() throws the Server Error in the third...
1
by: Manuel Lopez | last post by:
I get a run-time error 3035 ("system resources exceeded") running DAO code in XP x64 that works fine under 32-bit XP. It updates 405,000 records. Dim dbs as DAO.Database If dbs=Nothing Then Set...
20
by: Mark Harrison | last post by:
So I have some data that I want to put into a table. If the row already exists (as defined by the primary key), I would like to update the row. Otherwise, I would like to insert the row. I've...
0
by: saraDotNet | last post by:
hi everybody , I'm a beginner student in vb.net,and I'm working on a very small project as a homework,and I've some questions which I ought to search for their solutions via any source . My...
5
by: brino | last post by:
hi all ! i want to use the "like" function in a query but i want the user to enter the search variable. i have tried "like" but this doesnt return any results for some reason. any ideas ??? ...
3
by: eholz1 | last post by:
Hello PHP programmers. I had a brilliant idea on one of my pages that selects some data from my mysql database. I first set the page up to display some info and an image, just one item, with a...
6
by: Widge | last post by:
I can't believe it but I don't have a clue how to update a table using VBA! What I'm trying to do is: 1) Do a search on the last 3 periods turnover for one client in particular and check to see...
8
geolemon
by: geolemon | last post by:
I'm trying to perform an update, and I can't avoid this error - I've tried this query what must be 5 different very fundamentally different ways now. Arg. I used to be a DBA in large DB2 and SQL...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.