Query help

[rynorem]

I have an employee table in which one is date of hire.
I made a query which contains all the employees date of hire in one column. I now need a new column to which I can add 6 months (PERM DATE) to thier date of hire for perm status. I tried the date add function but could only get it to work with one date. How can I get my query to have the PERM DATE column add 6 months to all the dates of hire. Thanks

 

[Rich]

NewDate: DateAdd("m",6,[DateOfHire])

 

[rynorem]

New error

Thanks, Rich

When I do like you said I now get a Data type mismatch in criteria expression.