The DateSerial() function receives as input a year, month and day. It returns a date value. This function can be used to create date values to use in the criteria section of queries.
DateSerial(Year, Month, Day)
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com