I have one table with three fields; Aurthor, title and location.
I inported a text file into a table.
the firt record(1) has only the author in it and the other two fields
are nulls.
the nest 3 rows are related to the author, but the author fields have
a nulls in each three rows/records(2)..(4) have data in them.
Record(5) have only author in the first field and the rest of the
fields for this record are nulls. Records(6)..(12), is like the first
3 rows. Can some on help me with a script to clean up this table using
queries to link twpo relationalship tables, one authors and the othere
one tiltes/songs?
Thank U...
Doug
Example;
Author Title Locations
Nat 'King' Cole
Love 62-06
Ramblin' Rose 127-06
This Is All I Ask 41-09
Unforgettable 300-09
Shenandoah & Alison Krauss
Somewhere In The Vicinity Of The Heart 288-09
Costello & Bacharach
She 22-10
Shaggy & Brian & Tony Gold
Hey Sexy Lady 166-08
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
