Query Trouble

[klynch0803]

I have attached a small db that has 1 query with several fields..

Here is what I'm looking to do.

In the Query there is the following fields:

SignINMemberID
GuestOfMember
SignInDateTime
AllowedEntry

Now all these are derived from tdatMemberSignIn.

What I want to do is show the name that corresponds with the MemberID in table MemberList.

That means if the SignInMemberID exists it would show First and Last Name and if GuestOfMember is blank it would show nothing.

If the SignInMemberID doesnt exist but the GuestOfMember does then it would show the First and Last name beside that field.

If the number doesnt exist it would be blank.

I entered the places I wanted to show the data in the query for your reference as expr1, expr2, expr3, expr4 for your reference.

Any help would be appreciatted.

 

[klynch0803]

Maybe Best Way to Go

Maybe the best way to go is when I insert the MemberID in the table that I insert the First and Last Name at the same time then when I query its already there..