AmazonWendy
New member
- Local time
- Today, 12:11
- Joined
- Feb 16, 2016
- Messages
- 6
Hi all
What I'm looking for is help on which expressions can be used in calculated fields in tables. I'm trying to do a date difference calculation and I'm being told by Access that I can't use the Now() function or any of the other functions I've tried.
It seems to only allow simple calculations like [date1]+30 which won't do what I want.
I know how to do this in a query but my customer needs the date difference value to be visible in the table.
Any help greatly appreciated.
What I'm looking for is help on which expressions can be used in calculated fields in tables. I'm trying to do a date difference calculation and I'm being told by Access that I can't use the Now() function or any of the other functions I've tried.
It seems to only allow simple calculations like [date1]+30 which won't do what I want.
I know how to do this in a query but my customer needs the date difference value to be visible in the table.
Any help greatly appreciated.
