 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2008Query is blank if one subquery has no records
I have a query (CombinedQuery) that pulls values from two other queries to use on a subform. If Query2 has no records, then Query1 comes up blank also. Any idea why this happens? It be because of the way you connect the subquery. Post your query SQL.  SignatureKARL DEWEY Build a little - Test a little > I have a query (CombinedQuery) that pulls values from two other > queries to use on a subform. If Query2 has no records, then Query1 > comes up blank also. Any idea why this happens? You have an Inner join between them. Therefore they both need matching records or neither will show. In query design view double click on the join line between the two until a dialog box shows up. Try one of the other options and see what happens. SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > I have a query (CombinedQuery) that pulls values from two other > queries to use on a subform. If Query2 has no records, then Query1 > comes up blank also. Any idea why this happens? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.