Table Lookup

[bengalknights]

Hi All,

New to using access and my first query so be easy on me.

I have imported in two of my spreadsheets to a acess db.

The first has created the tables "Suppliers" which lists supplier name, account number etc.

The second has created the tables "Account Handlers" which lists the alphabet and the person who deals with that supplier which begins with that letter.

My question is how do i run a lookup/auto create a new table that shows all the supplier table plus a end column of who the account handler for that supplier is based on what the first letter of the name of supplier.

In excel i would have used the left formula (to cut give the first letter) then Vlookup (to give the account handler for that letter).

All help is much appreciated

 

[cookiegary01]

Hi,

Go to Video Tutorials, and check "How to create a relationship between 2 tables".
Then check Video tutorial for "Queries".
This will help for sure

 

[bengalknights]

You would use essentially the same procedure with VBA in Access except you use DLookup()

DLookup("PersonID","tblAlphabetCrossReference", "FirstLetter = '" & Left(Me.YourControlName, 1) & "'")

Thank you very much , this is exactly what i was trying to figure out, didnt realise that when you try to link tables they require a common factor, which neither of my tables do giving no results!

This seems to link them perfectly

 

[bengalknights]

Im starting to get the hang of table and relationships, however sql does look like a much better option for programming the querys through.

Is there any refer guides or books that have equivalent access instructions that are similar to excel?