Thanks for replies.

To give some more context to the fields used - the user of the database chooses which songs they want in the PowerPoint, each chosen song is then in a query with each verse, copyright info, etc. This might not be the best way to do this but there is then another query that pulls all of these individual queries together to give all the data required for the PowerPoint in one place. The fields are then in the format 'Song 1 chosen.verse 1' or 'Song 1 chosen.notes' etc. Looking back at my code (I wrote most of this a few years ago) I have used an underscore instead of a dot for the verses but have left it as a dot for the notes - both of these seem to work fine.
I will try renaming the fields to make sure I don't use any dots. Should the if statement then work?