DateAdd maybe? (1 Viewer)

[Design by Sue]

It has been a while since I worked in Access so I am definitely rusty!. I need to add a field to a query that takes a date field (CompletedDate) and adds the number of months listed in another field (Expiration). The original fields are in different tables but are combined within this query. This is really basic stuff for many of you but I am not getting it. Can someone possibly help me? The more specific your reply the happier I will be/

Thanks

 

[plog]

You're on the right track, just keep going.

MS Access: DateAdd Function

This MSAccess tutorial explains how to use the Access DateAdd function with syntax and examples. The Microsoft Access DateAdd function returns a date after which a certain time/date interval has been added.

www.techonthenet.com

As long as both fields are available in the query, and one is a date and one is a number you just use DateAdd like so:

NewDateFieldName: DateAdd("m", [FieldWithNumber], [FieldWithDate])

The only issues is null values in either of your fields, in which case you would need to handle them with a default value.

 

[Design by Sue]

I got it working!!!! I was not far off.