Outputing text based on a table

[Galphanore]

I have a table with three fields, StartDate, EndDate and Holiday Name. What I am trying to do is have a query search this table and determine if a date is between any of the startdate and enddate fields, and if it is have it output "Holiday", and have it output "Non-Holiday" if it does not.

 

[FoFa]

SELECT IIF(ISNULL([HolidayName]),"Non-Holiday','Holiday')
From HolidayTable
Where Forms!MyForm!DateParameter between [Startdate] AND [EndDate]

Something like that?