473,386 Members | 1,828 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,386 software developers and data experts.

SIMPLIFYING WORDS IN A TABLE

I need help in a description field within table which contains words like
"redirection" but also includes eg "redirection to Sydney". I need to
simplify this description to "redirection" only for summary purposes. Other
terms also exist in the description field which need to be simplified.

I am not using code but in a query I tried to use the SWITCH function in a
calculated field as follows:

Describe: Switch([Description]="*redirection*", "redirection") but Access
will not allow me to use wildcards within the function.

Does anyone have a solution which does not include code as I am unfamiliar
with writing Visual Basic.

I would be grateful for any help with this one - as you can tell I am no
expert in using Access.

Thanks
Christine


Nov 13 '05 #1
1 1347
On Mon, 12 Sep 2005 20:25:06 +1000, "Christine Henderson"
<ca****@idl.com.au> wrote:

If you use wildcards, you should use the LIKE keyword:
Describe: Switch([Description] LIKE "*redirection*", "redirection")

-Tom.
I need help in a description field within table which contains words like
"redirection" but also includes eg "redirection to Sydney". I need to
simplify this description to "redirection" only for summary purposes. Other
terms also exist in the description field which need to be simplified.

I am not using code but in a query I tried to use the SWITCH function in a
calculated field as follows:

Describe: Switch([Description]="*redirection*", "redirection") but Access
will not allow me to use wildcards within the function.

Does anyone have a solution which does not include code as I am unfamiliar
with writing Visual Basic.

I would be grateful for any help with this one - as you can tell I am no
expert in using Access.

Thanks
Christine


Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Matthew Cascio | last post by:
My understanding is that using reserved words as column names is allowable as long as they are quoted. I am trying to create a table dynamically with columns defined by the first row of a text...
7
by: HumanJHawkins | last post by:
Hi all, I have a table of text and associated data. I want to break apart the text into individual words, yet retain the data in other columns. For example: Sentence: Chapter:...
8
by: Peter Bungart | last post by:
I have a text field in Access (XP) that lists the occurrences of various plants, which are delimited within the field by commas (e.g., cactus, mesquite, yucca, cliffrose). Is there a way to...
5
by: sensible | last post by:
Can I solve this problem using Access? If so, will some give this newbie a simple step by step on how to go about it, please....all the way from File/New. In Excel I am using...
1
by: Benny Ng | last post by:
Hi,All, Export Method: ------------------------------------------------------------------------- strFileNameExport = "Results" Response.Clear() Response.Buffer = True...
7
by: Timo Haberkern | last post by:
Hi there, i have some troubles with my TSearch2 Installation. I have done this installation as described in http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words...
1
by: Hul Tytus | last post by:
comp.infosystems.www.authoring.html simplifying mailto In form entry code, the "POST action=mailto:xxx@xxx.xxx" command requests a Subject and a CC heading from the reader -- in lynx that is, I...
0
by: Pancrazio Balsamo | last post by:
Hello, No. Love must suffer in this stern world; it ever had been so, it ever would be so. The remembrance of that life is fraught with so much pain to me, with so much mental suffering and...
14
bugboy
by: bugboy | last post by:
I'm a beginner at this and am confused... I have three tables: 1. words / wordpk, word 2. definitions / definitionspk and definition 3. associations / wordpk, definitionspk 'words' holds...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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...

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.