Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.70K
1 Posted Topic
I have the following query in MS Access 2007 [CODE=sql]SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9 FROM Projects GROUP BY Projects.BIMinspector HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));[/CODE] How do I get it to return a result of zero if no records are found?? Any suggestions would be great. Thanks,
The End.