Adding a number field to a date

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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.
 
Back
Top