Age function and continuous form

  • Thread starter Thread starter george
  • Start date Start date
G

george

Hi to all,

I use an age function to calculate the client's age based
on his birhdate, this works fine on a single form.

Now I tried to do the same on a continuous form but it
doesn't work. On the form I include FName, LName, Sex,
Birthdate, CurrentAge. Is there a way to handle this?

thanks in advance, george
 
Hi,

george schreibselte:
I use an age function to calculate the client's age based
on his birhdate, this works fine on a single form.

Now I tried to do the same on a continuous form but it
doesn't work. On the form I include FName, LName, Sex,
Birthdate, CurrentAge. Is there a way to handle this?
Click to expand...

Make a query and calculate the age there.
The query bind to your form.

Acki
 
thank you acki for your reply. I'm afraid this won't work
namely to built a function inside a query upon which is
based a continuous form. But thanks again

george
 
Why doesn't it work? Just add an un bound field to your form (in the detail
section) and put in a formula to calculate age, such as...

=DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date
(),"mmdd"))


Or, you could do as the last posted suggests, and add a new column to the
underlying query such as...

CurrentAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))


and then you could just use the field [CurrentAge] in your report.


Your post says "it does not work" but you don't explain what it does. Are
you getting an error? What is your form based on? What formula are you
using?

Rick B
 
Rick
I was indeed hasty to say that it doesn't work, it works
fine. I apologize
thanks, george
-----Original Message-----
Why doesn't it work? Just add an un bound field to your form (in the detail
section) and put in a formula to calculate age, such as...

=DateDiff("yyyy",[Birthdate],Date())+(Format ([Birthdate],"mmdd")>Format(Date
(),"mmdd"))


Or, you could do as the last posted suggests, and add a new column to the
underlying query such as...

CurrentAge:
DateDiff("yyyy",[Birthdate],Date())+(Format ([Birthdate],"mmdd")>Format(Date(
),"mmdd"))


and then you could just use the field [CurrentAge] in your report.


Your post says "it does not work" but you don't explain what it does. Are
you getting an error? What is your form based on? What formula are you
using?

Rick B


thank you acki for your reply. I'm afraid this won't work
namely to built a function inside a query upon which is
based a continuous form. But thanks again

george
Click to expand...


.
Click to expand...
 
Back
Top