Update Query by Month Only

[Pappy]

I have a date and need to increase each one by 4 months. I'm currently just adding 120 days to it, but some of the dates are being put into the wrong month.

[tblMasterList]![Loan Effective Date]+120

I would like to just add 4 months to the month column and not touch the days. Example 4/27/01 would be 8/27/01....Can anyone help me out with this? All help is much appreciated!

Paps

 

[dcx693]

Use the DateAdd function with the "m" parameter to just add months. Check it out in the Access help.

 

[Pappy]

That worked wonderfully. Thanks for the help!