I have a database that keeps track of my music.
Some artists are individual people and others are musical groups.
What I have are fields as follows:
FirstName
LastName
Group
GenreID
ActivelyRecording
SongsSetUp
SongsDownloaded
So, in a query I want it to look like this:
Carey, Mariah
Coldplay
Midler, Bette
Mr. Mister
Presley, Elvis
So, if the group field is empty then the name is the individuals name. If the individuals name fields (First and Last) are empty and there is something in the Group field then the group name is put in the list.
I know how to set up a query, but, I just need to know what the syntax should look like to get the results above.
In my case, if the entry is a group then the first and last name fields are blank with nothing in them. Conversely, if the entry is a group then the first and last name fields are empty.
I would be grateful for anyone's help on this matter.
With gratitude,
Steven S.