<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Morning Keith,</DIV>
<DIV> </DIV>
<DIV>I don't know what I am trying to do now! I am just going around in a circle at the moment! :) I was attempting to link two tables which are related via post code to each other - the idea is that the tables will link automatically I think! - through the Auto look up function.</DIV>
<DIV> </DIV>
<DIV>I really have no idea personally. I prefer a vlook up table or even better an If statement in Excel.</DIV>
<DIV> </DIV>
<DIV>Hope this takes you away from the brick wall :)</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV>Emma Coughlan</DIV>
<DIV> </DIV>
<DIV>Emma Coughlan<BR>Information Technology/Sose Teacher<BR>St Helena Secondary College<BR>Eltham<BR><BR>>>> keithcr@fastmail.fm 02/06 2:38 pm >>><BR></DIV>
<DIV style="COLOR: #000000">Emma - I find that I can solve most Access problems with "Access 2000<BR>Bible" by Cary Prague & Michael Irwin.<BR>However, from your description "creating an auto look up query" I have<BR>hit the brick wall.<BR>What are you actually attempting to do?<BR>Ciao, Keith<BR><BR><BR><BR><BR><BR><BR>On Mon, 06 Feb 2006 11:17:56 +1100, "Emma COUGHLAN"<BR><ec@sthelena.vic.edu.au> said:<BR>> Hi everyone,<BR>> <BR>> I need help with creating an auto look up query using access. As you<BR>> need two tables my predecessor has not included a second table on the<BR>> network for me to complete the auto look up queries.<BR>> <BR>> Therefore I have to create another table which is fine - I can do that.<BR>> However I can not work out how to do the auto look up queries.<BR>> <BR>> I am at my wits end! I have the Barnes book currently in front of me<BR>> (the green one), been to the online help, I have books everywhere to<BR>> find out how to do this auto look up queries.<BR>> <BR>> Could anyone out there please PLEASE help me! - even if you send me two<BR>> tables which I can use to do the auto look up queries - it would be most<BR>> appreciated!<BR>> <BR>> Its on page 6-8 of the barnes book for anyone who has that book.<BR>> <BR>> Thanking you in anticipation :)<BR>> <BR>> Em Coughlan (Stressed out!)<BR>> <BR>> Emma Coughlan<BR>> Information Technology/Sose Teacher<BR>> St Helena Secondary College<BR>> Eltham<BR>Keith Richardson<BR>Leibler Yavneh College<BR>Elsternwick Ph (03)9528 4911<BR>keithcr@fastmail.fm<BR><BR>_______________________________________________<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au</A> - FAQ, resources, subscribe, unsubscribe<BR>VET IT Mailing List kindly supported by<BR><A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment Authority and<BR><A href="http://www.vitta.or
g.au ">http://www.vitta.org.au </A> - VITTA Victorian Information Technology Teachers Association Inc<BR></DIV></BODY></HTML>