Hi thanks for your help. Here is the SQL for the query:
SELECT TBLDayCheckLog.DayCheckLogID, TBLDayCheckLog.DateName, TBLDayCheckLog.DateToday, TBLDayCheckLog.UnformatDate, TBLDayCheckLog.ResEquCln, TBLDayCheckLog.ResEquClnComment, TBLDayCheckLog.CVEquCln, TBLDayCheckLog.CVEquClnComment, TBLDayCheckLog.StrMatCln, TBLDayCheckLog.StrMatClnComment, TBLDayCheckLog.EmerAlmTest, TBLDayCheckLog.EmerAlmTestComment, TBLDayCheckLog.RecepFirstAidKitAvail, TBLDayCheckLog.RecepFirstAidKitAvailComment, TBLDayCheckLog.PoolFirstAidKitAvail, TBLDayCheckLog.PoolFirstAidKitAvailComment, TBLDayCheckLog.PlantFirstAidKitAvail, TBLDayCheckLog.PlantFirstAidKitAvailComment, TBLDayCheckLog.FirstAidKit1Avail, TBLDayCheckLog.FirstAidKit1AvailComment, TBLDayCheckLog.FirstAidKit2Avail, TBLDayCheckLog.FirstAidKit2AvailComment, TBLDayCheckLog.GymClean, TBLDayCheckLog.GymCleanComment, TBLDayCheckLog.ChangRmClean, TBLDayCheckLog.ChangRmCleanComment, TBLDayCheckLog.PoolSideClean, TBLDayCheckLog.PoolSideCleanComment, TBLDayCheckLog.PlantClean, TBLDayCheckLog.PlantCleanComment, TBLDayCheckLog.SunBedClean, TBLDayCheckLog.SunBedCleanComment, TBLDayCheckLog.SteamRmClean, TBLDayCheckLog.SteamRmCleanComment, TBLDayCheckLog.SaunaClean, TBLDayCheckLog.SaunaCleanComment, TBLDayCheckLog.BeautyRmClean, TBLDayCheckLog.BeautyRmCleanComment, TBLDayCheckLog.RecepClean, TBLDayCheckLog.RecepCleanComment, TBLDayCheckLog.ChildPlayClean, TBLDayCheckLog.ChildPlayCleanComment, TBLDayCheckLog.StoreRmClean, TBLDayCheckLog.StoreRmCleanComment, TBLDayCheckLog.DanceStudClean, TBLDayCheckLog.DanceStudCleanComment, TBLDayCheckLog.Blank1, TBLDayCheckLog.Blank1Comment, TBLDayCheckLog.Blank2, TBLDayCheckLog.Blank2Comment, TBLDayCheckLog.Blank3, TBLDayCheckLog.Blank3Comment, TBLDayCheckLog.Name, TBLDayCheckLog.Date, TBLDayCheckLog.AgreeCheck
FROM TBLDayCheckLog
WHERE (((TBLDayCheckLog.UnformatDate) Between GetDateBegin() And GetDateEnd()));
If you prefer it in word format let me know.
Thanks
Inky
Hampshire UK.
A fool and his money are soon parted - so you might as well send it to me!