I need to query a table with three columns, Authors, Songs and location;
In the Author Field, it has many Author names and with 1.. to many
empty data
or nulls in the authors field [authors] too.
Need to know how to creat two relational tables, one authors and one songs
with my data. Can some one show me how ?
Email me at [EMAIL PROTECTED]
Thank U...
example of table;
Author Songs Locations
Nat 'King' Cole null null
null Love 62-06
null Ramblin' Rose 127-06
null This Is All I Ask 41-09
johnny cash Null Null
null Burning fire 45-05
null Old Ruged cross 76-06
.
.
.
end of file
Appreciate any help or Suggestion to place the authors in the null field.
Thank U...
Doug
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/