Telephone Directory

[chris]

I am trying to put our company telephone lists into an Access database with the view of the users being able to use a search form to locate the number of the individual they need. Could somone please give me a few pointers on this

Thanks in advance

Chris

[whkoh]

How do you want it to be (be more specific)?

[DaFunk]

really i need more info but if you need a sql statement, something like this should work where strlastname and strfirstname are the values inputted from the search form.
However if two people have the same name then you need a employee id field to search from

strsql = "select telnumber from table where firstname = " & strfirstname & " and lastname =" & strlastname

if you need more help mail me

dafunk

dafunk@madasafish.com