General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Query Expression in Access problem
Im tearing my hair out here!!! I am trying to work out an age from a date of birth and using the Now() function in Access.
The problem is that any date of birth over 1972 -i.e. 16/09/1973 - shows as 4 figures even though I have formatted the field to yy and zero decimal places. The formula I have used for the expression is, AGE: Now()-[dob]
Has anyone any ideas
Thanks
Brian