Kamis, 31 Oktober 2013

[MS_AccessPros] How to combine several memo fields into one memo field? Why bother?

 

I really, really, really wouldn't do this. You can't sort on memo fields - i.e. if someone writes something you want, you have to skim the memo messages to find it, unless you have a tag/topic field to sort.
The only time I use a memo field is when I'm writing up a listing to sell something. That record also has a tag field, so that I can find and sort the memos by item (subject).
I make notes on books I've read, and comments on stocks I'm interested in using a text field. In both cases I have a seq field that I use if a comment runs longer than the text limit. 1 is the first part of the comment, 2 is the second part, etc. It's easy enough to concatenate fields.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar