Return 0%

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table where I have a field where a percentage is saved (budget
percentage). In some cases, the budget percentage is 0%.

I have the following query:
SELECT qryTSExport.LastName, qryTSExport.FirstName, Sum(qryTSExport.Hours)
AS SumOfHours, qryTSExport.PSUID, tblEmpDept.DirBugPer, tblEmpDept.Dept
FROM qryTSExport INNER JOIN tblEmpDept ON qryTSExport.PSUID = tblEmpDept.PSUID
WHERE (((qryTSExport.Date) Between #9/1/2007# And #9/30/2007#))
GROUP BY qryTSExport.LastName, qryTSExport.FirstName, qryTSExport.PSUID,
tblEmpDept.DirBugPer, tblEmpDept.Dept;

In the properties for DirBugPer, I have Format field set as #%. My problem
is, in my table where I have 0% saved, it shows 0%, however in the query, the
result is just %. When I use the nz() function, I lose my formatting.

This probably doesn't have anything to do with it, but I'm using Access
2007. In Access 2003 (previous files that I have this field saved), my query
result shows 0%.

Thanks in advance for your help!
 
Back
Top