I need to use an expression in the first part of an IF statement that checks a certain query to see if there are any results or no results.

I don't know haow to assign a value to strQueryName.Records in the example below or if this will even work.

EX:

For intAnnex = 10 to 23

Select Case (intAnnex)

Case(20)
strQueryName = "My Query#20"

Case(23)
strQueryName = "My Query#23"

If ????strQueryName.Records??? is null Then Next intAnnex

DoCmd.SendObject acSendQuery, "Annex18 Expired Report Query", acFormatHTML, strEmail, , , "Expired License Notification", "Message Text"

Next intAnnex

If DCount("*","QueryName")<=0 Then