display null values

Hi,

I have the following problem.

I have created different tables in my database with descriptions in from other tables (example : a table named errors with errorid and errordescription as fields in it)

In a report i want to display the total nr of errors during a certain period for a certain department.

i have created that report with a list (by department). in this list i have a table where i group my errors.

until here all ok. when i display my report it shows all the errors.

but what it doesn't show is all the errors who have value 0 (or errors that didn't occur during that period i defined)

how can i display all my errors, even if they did not occur (0 times)

Greetings

vinnie

hi Vsempoux

I am a little confused as to this line

"but what it doesn't show is all the errors who have value 0 (or errors that didn't occur during that period i defined)"

are you trying to show all errors or no errors ?

Bernard

|||

Hello Vinnie,

I think you need to change your data query to left outer join instead of inner join. Can you paste your query?

Hope this helps.

Jarret