I have a subform that displays a list of song titles linked to a particular album id. Some songs exist on more than one album, and I wanted to create a conditional format that would color any song that exists on multiple albums. I made a few attempts but so far nothing works. One thing that doesn't work, for example, is:
Code:
("SELECT Count(LPContents.song_id) FROM LPContents where LPContents.song_id = " & [SongID])>1
I don't know if this is close but I just have syntactical issues or whether this is completely improper and useless. It was just my best guess as something that seemed like it might work.
Info on underlying structure: The song titles and song ids are in Songs, the list of albums is in LPs, and LPContents has a key to match each id in Songs to the id of a particular album in LPs. So I can create a list of titles with the query:
Code:
SELECT Songs.Title, Songs.SongID, LPContents.LP_id
FROM LPContents INNER JOIN Songs ON LPContents.song_id = Songs.SongID
WHERE ((([LPs].[LPID])=[LPContents].[LP_id]))
ORDER BY LPContents.Side, LPContents.Track, Songs.SongID;