BlueIshDan
☠
- Local time
- Today, 13:45
- Joined
- May 15, 2014
- Messages
- 1,122
Hello lads & lassies!
I have myself in a sticky situation. I've been assigned to do some work on this project management database that was built by numerous people in the past.
I need an explanation as to why this query is capable of returning 2 of 38 """possible""" records.
Query
When [Forms]![frmMain]![cboProjectNum] is requested as a parameter I put in C00031. There are 38 records in tblEWO_AdditionInfo with that project number. The query returns 2 records.
THE CATCH IS!!!!!!!!!! tblProArcEWOs is empty! hahaha
WHAT'S GOING ON HERE!
I have myself in a sticky situation. I've been assigned to do some work on this project management database that was built by numerous people in the past.
I need an explanation as to why this query is capable of returning 2 of 38 """possible""" records.
Query
Code:
SELECT
tblProArcEWOs.[Project ID],
tblProArcEWOs.[EWO Number],
tblProArcEWOs.Rev,
tblProArcEWOs.Description,
tblProArcEWOs.Date,
tblProArcEWOs.STATUS,
tblProArcEWOs.[Project ID],
tblProArcEWOs.[EWO Number],
tblProArcEWOs.Discipline,
tblProArcEWOs.Resource,
tblEWO_AdditionInfo.[Planned Date],
tblEWO_AdditionInfo.[Forecast Date],
tblEWO_AdditionInfo.[Actual Date],
tblEWO_AdditionInfo.[EWO Comments]
FROM
tblProArcEWOs
LEFT JOIN tblEWO_AdditionInfo
ON (tblProArcEWOs.Rev = tblEWO_AdditionInfo.Rev)
AND (tblProArcEWOs.[EWO Number] = tblEWO_AdditionInfo.[EWO Number])
WHERE tblProArcEWOs.[Project ID] Like [Forms]![frmMain]![cboProjectNum]
ORDER BY tblProArcEWOs.[Project ID];
When [Forms]![frmMain]![cboProjectNum] is requested as a parameter I put in C00031. There are 38 records in tblEWO_AdditionInfo with that project number. The query returns 2 records.
THE CATCH IS!!!!!!!!!! tblProArcEWOs is empty! hahaha
WHAT'S GOING ON HERE!