Adding a number field to a date

message from Matt on 21 May 2004
I am looking for a way to take a field formatted as
numbers but representing months, and adding it with a date
(mm/yyyy). In a simple add Access assumes the number
field is days, not months, with a DateAdd [e.g. DateAdd
('mm/yyyy', numberfield, datefield)] yields an error in
the query results. It's probably something simple I'm
missing here...any thoughts? Thank you.
 
Allen Browne replied to Matt on 22 May 2004
DateAdd("m", [numberfield], [datefield])
 

Archived message: Adding a number field to a date (Microsoft Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.