T
Terry
I haven't touched Access for a year or more and I'm having trouble adding
criteria to queries to manipulate text.
It took me only a few minutes to remember the format of the Left() and Mid()
'commands' but now I want to do more complex manipulations.
For instance I want to locate the position of a string of text within a
field and then trim the string to one char past that point. I was last using
office2k and i knew exactly where to find the format of these expressions
within the Help app - from there I could work it out myself. OfficeXP Help,
however, seems more intent on giving me a limited number of examples to work
with, rather than telling me where i can find a list of commands I can work
with.
Can somebody tell me exactly where I can find the alphabetical list of
commands (are they methods, properties, events, functions?) so that I can
get in there and kickstart my synapses.
TIA
Terry
criteria to queries to manipulate text.
It took me only a few minutes to remember the format of the Left() and Mid()
'commands' but now I want to do more complex manipulations.
For instance I want to locate the position of a string of text within a
field and then trim the string to one char past that point. I was last using
office2k and i knew exactly where to find the format of these expressions
within the Help app - from there I could work it out myself. OfficeXP Help,
however, seems more intent on giving me a limited number of examples to work
with, rather than telling me where i can find a list of commands I can work
with.
Can somebody tell me exactly where I can find the alphabetical list of
commands (are they methods, properties, events, functions?) so that I can
get in there and kickstart my synapses.
TIA
Terry