ok found the param thats giving me the issue:
heres the statement
strSQL = "SELECT hrs, bs, dte, emp FROM emphrs WHERE (((emp)= 'Andy') AND ((Weekday([dte],1))=1) AND ((Month([dte]))=Month(Now())));"
its the name of the employee in single quotes which works but i have a field on the form that i...