wv_guy_26301
Registered User.
- Local time
- Today, 17:48
- Joined
- Jan 12, 2010
- Messages
- 12
Query not returning all records **Issuse Solved **
This is the Access 2007 database i'm working on and I'm hitting a wall.
When you run "Member Query" it does not return all the records in the database
The field's in the query are
Member:Last name
Member:First name
Member:chapter
Options: ID
There is a relationship between Member:ID and Options:sponsor number
What I'm trying to do is list member names and just the ID numbers of thier guest and spouse. I want all members listed even if they do not have a guest or spouse.
how I have it set up, if a member has a spouse then that spouse puts the members ID number in their sponsor number box. when the query is run, the spouse's ID is listed with the members name. but if a member is alone and the member's ID is not listed in anyones sponsor box their name IS NOT returned in the query.
Below is the Database i'm talking about, Thanks for any help!
This is the Access 2007 database i'm working on and I'm hitting a wall.
When you run "Member Query" it does not return all the records in the database
The field's in the query are
Member:Last name
Member:First name
Member:chapter
Options: ID
There is a relationship between Member:ID and Options:sponsor number
What I'm trying to do is list member names and just the ID numbers of thier guest and spouse. I want all members listed even if they do not have a guest or spouse.
how I have it set up, if a member has a spouse then that spouse puts the members ID number in their sponsor number box. when the query is run, the spouse's ID is listed with the members name. but if a member is alone and the member's ID is not listed in anyones sponsor box their name IS NOT returned in the query.
Below is the Database i'm talking about, Thanks for any help!
Last edited: