[Year 12 IT Apps] Access Help Please!!!

[Keith Richardson]

Elegant, Jock!!!
I never knew that you could simply put a formulae into a textbox on a
form to show the result of a formulae.
This has solved problems and dreams I have had over the years.
I love this list!!
Thank you Jock. Keith



On Wed, 28 Feb 2007 10:36:05 +1100, "Jock Garnsworthy"
<ga at willihigh.vic.edu.au> said:
> I like teaching students how to write formulae in a text box on a form or
> in
> a new field in a query and I use
> =int((now()-[DOB])/365.25 to calculate someone's age as an example of
> formulae. 
> 
> 
> Cheers,
> 
> Jock
> __________________________
> Jock Garnsworthy
> Pasco St. 
> Williamstown High School
> (03)93971899
> 
> On 28/2/07 9:23 AM, "Lumsden, Richard G"
> <lumsden.richard.g at edumail.vic.gov.au> wrote:
> 
> > 
> > Is this what would help, Keith?
> > 
> > http://office.microsoft.com/en-au/access/HA010550711033.aspx?pid=CL10057
> > 0041033
> > 
> > -----Original Message-----
> > From: itapps-bounces at edulists.com.au
> > [mailto:itapps-bounces at edulists.com.au] On Behalf Of Keith Richardson
> > Sent: Tuesday, 27 February 2007 11:13 AM
> > To: List IP&M
> > Subject: [Year 12 IT Apps] Access Help Please!!!
> > 
> > Hi all you Access Experts.
> > Three of us have a problem - how do we get Access to tell us which age
> > group an individual belongs to (Junior 10-12, Intermediate 13-14, Senior
> > 14-18) starting with date of birth (an entered field in the members
> > table). We worked out how to create a query that would get current age
> > based on date-now and dob, then selection based on a particular age
> > range for criteria, but that simply gives me a list of member names who
> > fall into
> > that age group at any time. What I want to do is flow that information
> > into something that will flow into a report, without having to manually
> > look through the lists of names of members in a particular age group.
> > Hope that isn't too complicated!
> > Regards, Keith (for Keith, Henry & Diane)
> > Keith Richardson
> > 
> > _______________________________________________
> > http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> > IT Applications Mailing List kindly supported by
> > http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> > Authority and
> > http://www.vitta.org.au  - VITTA Victorian Information Technology
> > Teachers Association Inc
> > 
> > Important - This email and any attachments may be confidential. If received in
> > error, please contact us and delete all copies. Before opening or using
> > attachments check them for viruses and defects. Regardless of any loss, damage
> > or consequence, whether caused by the negligence of the sender or not,
> > resulting directly or indirectly from the use of any attached files our
> > liability is limited to resupplying any affected attachments. Any
> > representations or opinions expressed are those of the individual sender, and
> > not necessarily those of the Department of Education.
> > _______________________________________________
> > http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> > IT Applications Mailing List kindly supported by
> > http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> > http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> > Association Inc
> 
> 
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
Keith Richardson
ITA List Moderator
Head of ICT, Leibler Yavneh College
Elsternwick
Ph: 03.9528.4911
k.richardson at yavneh.vic.edu.au