Hi
I am building a query which has numerous fields. I require one of these to be 'Age at Application', but age is not held anywhere in the tables, there is only app date and birth date. I am trying to get age to appear using
This works when I use it in a query with only a few fields, but with all the rows/records that will be used in the final query. However when I try to incorporate it into the main query, either directly as a field or via another query, I get the 'overflow' error.
I've had a look around for some ideas as to what is causing this but everything refers to things which don't seem relevant, especially as the formula works fine for the full data-set when there are simply less fields.
I hope that makes sense, any help would be great.
Thanks
Bookmarks