So I am running a query against a table to return the total number of records within the table, this number changes following data imports.
Viewing the table there are 550 records.
Running just the query against the table returns a 550 count, but
Running the query after associating it with these other queries returns a count 654 records.
Why does the record count of the table keep increasing?
[SELECT Count(tblMasterFile.Count) AS Assigned, Count(qryPFTTrained.[PFT Trained]) AS PFTComplete, Count(qryCFTTrained.[CFT Trained]) AS CFTComplete, Count(qryRIFLE.[Rifle Untrained]) AS NoRifle, Count(qryRIFLETrained.[Rifle Trained]) AS Rifle
FROM (((tblMasterFile LEFT JOIN qryPFTTrained ON tblMasterFile.EDIPI = qryPFTTrained.EDIPI) LEFT JOIN qryCFTTrained ON tblMasterFile.EDIPI = qryCFTTrained.EDIPI) LEFT JOIN qryRIFLE ON tblMasterFile.EDIPI = qryRIFLE.EDIPI) LEFT JOIN qryRIFLETrained ON tblMasterFile.EDIPI = qryRIFLETrained.EDIPI;]
Thanks for any help.
Scott
Viewing the table there are 550 records.
Running just the query against the table returns a 550 count, but
Running the query after associating it with these other queries returns a count 654 records.
Why does the record count of the table keep increasing?
[SELECT Count(tblMasterFile.Count) AS Assigned, Count(qryPFTTrained.[PFT Trained]) AS PFTComplete, Count(qryCFTTrained.[CFT Trained]) AS CFTComplete, Count(qryRIFLE.[Rifle Untrained]) AS NoRifle, Count(qryRIFLETrained.[Rifle Trained]) AS Rifle
FROM (((tblMasterFile LEFT JOIN qryPFTTrained ON tblMasterFile.EDIPI = qryPFTTrained.EDIPI) LEFT JOIN qryCFTTrained ON tblMasterFile.EDIPI = qryCFTTrained.EDIPI) LEFT JOIN qryRIFLE ON tblMasterFile.EDIPI = qryRIFLE.EDIPI) LEFT JOIN qryRIFLETrained ON tblMasterFile.EDIPI = qryRIFLETrained.EDIPI;]
Thanks for any help.
Scott