Simple Query Question

[Delali Dzirasa]

I am trying to make a query from two tables in my database. The database
will be an action item tracker....


Table 1 has the following:
ACTION_ITEM
ActionItemNum, Task, AssignedTo, AssignedBy, DateForReview, DateForApproval,
DateForDelivery, Description, Etc.....

ActionItemNum is the primary key in this table.

AssignedTo and AssignedBy are both integers that reference users in the USER
table as follows:

uid, Name, Address, Etc......

I would like to create a query that will return all action items but instead
of showing the AssignedTo and AssignedBy integer values I would like it to
show the actual name referenced in the USER table. I know how I would do
this via vb, but I wanted to know if I could just create a query and would
display all of this at once.

I will need this to work for access and SQL Server.

Any assistance on this?

Thanks!
Delali

 

[John Vinson]

I wanted to know if I could just create a query and would
display all of this at once.

Of course. That's how queries work!

Just create a Query joining the two tables on UserID; display
whichever fields you want from either or both tables.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps