FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
|
|
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 |
| Merge fields in ACCESS |
| Author: | Vincent Maes |
| Date: | Monday, 17th Jun 2002 13:08 |
| Views: | 3,105 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b18294 |
|
With the topic 'Using ACCESS in a small library', I've seen how expert some Free Pinters are.
So, I will try with this one : in a small bibliographic access db, I would like to merge some fields in a report, horizontally or vertically. More clearly, without the blanks at the end of each field. A kind of 'trim()' function for dbase aware people.
I once asked this question to a 'guru', and the answer was to have a report per length... Nice answer, indeed.
So, I'm hoping someone has THE solution. Anyway, many thanks in advance.
With best regards,
Vincent Maes, ANMC-DI, Brussels
|
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Merge fields in ACCESS | | With the topic 'Using ACCESS in a small library', I've seen how expert some Free Pinters are.
So, I will try ... |
|
Vincent Maes |
17/06/02 13:08 |
18294 |
 | Re: Merge fields in ACCESS | | You can "merge" in either a query or a report by doing the following:
Select the "Build" option
the syntax is:
[Field]& ... |
|
Hilary |
19/06/02 14:08 |
18361 |
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.
|
|
