I have a query which needs to combine the reslts of two other queries so that the record set looks like one table with the combined unequal fields from both query results.
The two source queries summarize some totals and create exactly one record of summary total fields.
In my QBE grid, I have the two Queries posted and have all their fields listed down on the grid.
Example:
qryInventory
Creates one record with fields tot1, tot2
qryOnOrder
creates one record with fileds tot3, tot4.
Fields tot1, tot2, tot3 tot4 are all on the QBE grid.
This works OK as long as both queries return a record. In the case that , say qryOnOrder does not return a record and the recordset is null, the whole recordset results becomes null for the entire query.
Is there any simple way I can instruct the Query to build the result even if one of the two source queries return a null recordset?
THX!!
Keith
The two source queries summarize some totals and create exactly one record of summary total fields.
In my QBE grid, I have the two Queries posted and have all their fields listed down on the grid.
Example:
qryInventory
Creates one record with fields tot1, tot2
qryOnOrder
creates one record with fileds tot3, tot4.
Fields tot1, tot2, tot3 tot4 are all on the QBE grid.
This works OK as long as both queries return a record. In the case that , say qryOnOrder does not return a record and the recordset is null, the whole recordset results becomes null for the entire query.
Is there any simple way I can instruct the Query to build the result even if one of the two source queries return a null recordset?
THX!!
Keith