Query with no data, neeed help

[nilses]

Hello,

I have a problem concerning the queries. I would like to post Zero when my query is empty. I have make this query but in the field of my query, I do not have data. How then I to make.

SELECT Sum([REPORTING: Hors Délais > 6H00 NB (Nombre)(base)].Nombre) AS Nombre
FROM [REPORTING: Hors Délais > 6H00 NB (Nombre)(base)];

As Nombre equal no data but i would like 0.

This problem comes from my report. I created a report and which will become under report by the means of a query. I created a major report with my sub report. But if me query is empty, my sub query does not exist. How then I to make to put zero when I did not give in my fields. I had tested with the iif one but without result.

Thanks you for your help.

Nilses

 

[ptaylor-west]

Just make the default value for the field 0 (Zero) so that it would never be empty

 

[Rich]

Search the forum for examples of the HasData method.