Access Templates

[DjNav]

Hi All,


Just wanted to know if anyone knows about a template i can use where i can enter all the data in...eg postcodes and a name of the 1st driver and 2nd driver..


Then all you have to do is enter postcode and it tells you who the driver is..


Please Help

[trevor40]

what your after is a table with driver1, driver2, postcode.
then create a query based on that with all fields, in the criteria for the postcode field enter ' [Enter Postcode to find Driver] '
when you run this it will ask for the postcode and only display the records the match it.

[DjNav]

I wish i knew how to do that thats why i was after a temp. or if anyone knew of one i can use...
Is they a yourtube video on how to do this

[trevor40]

I wish i knew how to do that thats why i was after a temp. or if anyone knew of one i can use...
Is they a yourtube video on how to do this

and then
' help create simple query winxp access 2003 '