Member Avatar for mela1006

I have the following query in MS Access 2007

SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9
FROM Projects
GROUP BY Projects.BIMinspector
HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));

How do I get it to return a result of zero if no records are found??

Any suggestions would be great.

Thanks,

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by cgyrob
Member Avatar for cgyrob

Try This

SELECT Projects.BIMinspector, Sum(NZ(Projects.R9,0)) AS SumOfR9
FROM ProjectsGROUP BY Projects.BIMinspectorHAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));
Edited by cgyrob because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.