[Year 12 IT Apps] Access Help Please!!!
Mark Kelly
kel at mckinnonsc.vic.edu.au
Tue Feb 27 12:29:48 EST 2007
Nested/multiple IFs? VLOOKUP is always easier and faster...
http://www.mckinnonsc.vic.edu.au/la/it/ipmnotes/howto/nestedif.htm
:-)
Tony Beggs wrote:
> Keith
> I would be interested in this one also
> Currently I transport the total member file into Excel, run a multiple IF statement over the lot and then return the new data at the start of the season into the Access DBMS.
> Tony
> St Patrick's College Ballarat
>
>
> ________________________________
>
> From: itapps-bounces at edulists.com.au on behalf of Keith Richardson
> Sent: Tue 27/02/2007 11:12 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
--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000 << new number!
School Fax +613 9578 9253
Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IPM Mailing List
Doctor - We must all face reality sooner or later.
Dowd - I wrestled with reality for 35 years, doctor, and I'm happy to
say I won out over it. ('Harvey', 1950)
More information about the itapps
mailing list