Newbie Question

R

redeagle76

I have trying to setup a database for inventory back from repair. I would
like for it to auto populate a date 5 days and 15 days from we receive the
inventory. Any help would be great
 
J

John W. Vinson

I have trying to setup a database for inventory back from repair. I would
like for it to auto populate a date 5 days and 15 days from we receive the
inventory. Any help would be great
Click to expand...

Such a date should NOT be stored in your table, at all.

Instead calculate it on the fly; in a query you can type

FiveDaysLater: DateAdd("d", 5, [DateReceived])

and similarly for 15.

Note that this is five calendar days, not dealing with holidays or weekends.
 
Top