site ID!

[andrewvranjes]

guys!

i am having trouble displaying SiteID field.

i have only modified your sql code by adding SiteID into it and taking out JobCode.........

SELECT CompanyName, JobCode, Count(*) as NumOfRecords
FROM [BP Hose query]
GROUP BY CompanyName, JobCode

SELECT CompanyName, SiteID, Count(*) as NumOfRecords
FROM [BP Hose query]
GROUP BY CompanyName, SiteID

and a dialog box appears asking for the SiteID !

i dont get it!

please help again!




Andrew

 

[DJN]

Check to make sure that SiteID is in the query BP Hose Query.

David