Rows with missing data are not shown. Why?

[yellowgelb]

Hi
I am using the following code for a query to show data in a combo box. The Query is working, but I also need to see the rows where I got only data for the event and the region and no maximum or minimum date data. Can anyone help me to fix my problem?

SELECT tblEvent.EveNumber, tblEvent.EveRegionRef, Min(tblBasicData.CatDate) AS MinOfCatDate, Max(tblBasicData.CatDate) AS MaxOfCatDate
FROM tblEvent INNER JOIN tblBasicData ON tblEvent.[EveNumber] = tblBasicData.[CatEventRef]
GROUP BY tblEvent.EveNumber, tblEvent.EveRegionRef;

Thanks a lot for your help!!!

[NoellaG]

Hi,

you could try to use a left outer join between the tables in stead of an inner join.

[yellowgelb]

Thanks to you NoellaG!
Now it's working. Great.