Calculated fields in a database
neil at holsdev.vispa.com
Wed Jun 27 08:39:25 BST 2007
On Tue, 26 Jun 2007 10:51:57 -0500
manchicken <manchicken at notsosoft.net> wrote:
> You could always just stick it into your query. I don't know how to do this
> in MySQL, butyou could just turn the two dates to epoch, subtract today from
> the birthdate, and then divide it by (60*60*24*365.25) to get the years.
> ~ manchicken <><
> (A)bort, (R)etry, (I)nfluence with large hammer.
> 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
Yes, of course there will be ways around it. But in my original email I
was not talking about a query, I was referring to using a normal form
to move through records. A calculated field looks like a normal field
when viewing. But, as I said, it is not picking up data from a table it
is showing the result of a calculation.
More information about the kubuntu-users