This is my query, can you take a look to see wat wrong with it? Thank you very much.
SELECT Nz([ScanHour],0) AS [Scan Hour], Nz([OtherHour],0) AS [Other Hour], Nz([TotalHour],0) AS [Toal Hour], Nz([OtherWork],"") AS [Other Work]
WHERE (((tblWorkHour.WorkDate)=[Forms]![FrmReport]![StartDate]) AND ((tblWorkHour.EmployeeID)=CurrentUser()));
create a table with the fields you have in your query that you use in your report. Then in your report's open event check the report's Hasdata property. if it doesn't have any data which means your query returns nodata, change the report's recordsource property to this empty table.
something like this:
Private Sub Report_Open(Cancel As Integer)
If Not Me.HasData Then Me.RecordSource = "table1"
' table1 is the table with default values.
I hope this helps.