FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
My Account »
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Microsoft Access Expression |
| Author: | Sandra Graham |
| Date: | Thursday, 31st Jan 2002 09:59 |
| Views: | 3,671 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b15452 |
|
I need some help with getting the syntax of an Access expression to work. I am trying to extract the text of the first (ie left) complete word value from one field to another blank field. I am able to do this with a fixed number of characters using the following expression for eg 5 characters:
Left([FieldName],5)
but how do I do it for a variable length string? Any Access experts know the answer? |
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Microsoft Access Expression | | I need some help with getting the syntax of an Access expression to work. I am trying to extract ... |
|
Sandra Graham |
31/01/02 09:59 |
15452 |
|
Phil |
01/02/02 12:11 |
15492 |
|
Sandra Graham |
01/02/02 14:29 |
15500 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
