Rich_Lovina
Registered User.
- Local time
- Tomorrow, 08:32
- Joined
- Feb 27, 2002
- Messages
- 225
Okay, returning to Access, can this be done in the table design? or
Must it be a Query-Make Table, or
Is it a job for a Module?
I have a long text field (64chrs), some are blank, others one word, and problem samples are
Association
Association xyz xxxxxx
Association xya yyyyy xxx
abcde xxx cc ddddd Association
I seek to derive a unique textstring to serve as a primary field in a related table.
Second part: There are c.50,000 records, of which c.16,000 contain text data, and 4750 react to IS NOT NULL as if they contain data, but are in fact blank (Have checked for blank spaces and it appears none), so why IS NOT NULL or <>" " both turning up the 4750?
Must it be a Query-Make Table, or
Is it a job for a Module?
I have a long text field (64chrs), some are blank, others one word, and problem samples are
Association
Association xyz xxxxxx
Association xya yyyyy xxx
abcde xxx cc ddddd Association
I seek to derive a unique textstring to serve as a primary field in a related table.
Second part: There are c.50,000 records, of which c.16,000 contain text data, and 4750 react to IS NOT NULL as if they contain data, but are in fact blank (Have checked for blank spaces and it appears none), so why IS NOT NULL or <>" " both turning up the 4750?