GAZZAT5
Board Regular
- Joined
- Feb 8, 2005
- Messages
- 68
I have a loans table that contains the days, [days loaned], and weeks, [weeks loaned] loaned for as fields, and I want it to work out the return date from the date loaned, [date loaned] based on these values.
So the Default Value ofn the return by field would be
where [weeks loaned] and [days loaned] are both numbers with field size byte, and [date loaned] and [return by] are dates.
Yet when I try to save it, it comes up with the error:
Many thanks
So the Default Value ofn the return by field would be
Code:
=DateAdd("ww",[weeks loaned],DateAdd("d",[days loaned],[date loaned]))
where [weeks loaned] and [days loaned] are both numbers with field size byte, and [date loaned] and [return by] are dates.
Yet when I try to save it, it comes up with the error:
[The database engine does not recognize either the field 'weeks loaned' in a validation expression, or the default value in the table 'loans'.
Many thanks