I have a database containing 3 tables. If I run a query calling for values from all of the three tables, the only recordset which is built is that of items with values in ALL 3 tables. For instance, if my attributes table doesn't display a value for languages on application ID # 1234, 1234 will not appear in the recordset. I need a recordset built of ALL tables regardless if a field is holding a null value. How can I accomplish this? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Queries with Null Values
- Thread starter f5snopro
- Start date
You need to change your join type. In the QBE when you are creating your query you drag a join from one table to the other. Double click on the line itself or right click and select join properties. REad carfully and make your selection acordingly.
Good Luck
ssecca
Good Luck
ssecca
- Thread starter
- #3
Actually...it goes beyond the Null issue. I have the two tables linked by Application ID. IF the main table has an application id but the attribute table doesn't have a matching ID, the record for that application will not be returned. I want it to return the application info and if it doesn't have an ID in the attribute table, still present the fields within that table, but leave them blank. Is this possible?
YES! goto the Query designer, where you have created the link linking the two tables double click on the linking line itself. This will open a new window that will allow you to modify the type of link(Join) that exist now. You wnat to select either option 2 or option 3 depending on how you set up the query originally. Try it both ways and I'm sure you will find you answer.
Good Luck
ssecca
Good Luck
ssecca
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question