Patrick Wilmore has a problem with space: he has too much and he wants to get
rid of it. He has two tables in an Access database that come from different
sources and both have a text field for holding numeric ID codes.
Unfortunately, the data from one source is entered in the form ‘123 456 7890’
and the other is entered as ‘1234567890’.
Patrick wants to convert the data by removing spaces from the strings held in
the first format so all IDs are stored in the second, spaceless format.
Welcome to the wonderful world of text handling. Access has a range of text
functions for manipulating a string of characters which will allow you to do
almost anything.
We’ll use the text functions in expressions in a query, so open a new query
grid and add the IDTable. This table is a simple soul comprising one column with
the spaced strings.
You can download the table and the associated queries from
here.
Are you stuck in a dead end job? Do you want to take control of your salary, life and career? Advent IT and computer training offers advanced, professional training and helps you find the right ... more >
Are you stuck in a dead end job? Do you want to take control of your salary, life and career? Advent IT and computer training offers advanced, professional training and helps you find the right ... more >
Data Assurance Manager - Up to £30,231 plus benefits - SouthwestEnjoy this exciting opportunity to drive your career forward and really make your mark in our large, national organisation. At VOSA your specialist skills will ... more >
Shinfield Park, Reading, United Kingdom | Foster Wheeler
Our UK-headquartered operations employ more than 6,000 people and we are seeking qualified and experienced IT professionals to work in our head office in Reading, Berkshire. We are currently seeking an Analyst Programmer to join ... more >More job opportunities
Print
Discuss
Send to friend
RSS feeds
del.icio.us
Digg this
reddit!
