Hi All, I'm working on a forecas

[dacllog]

Hi All,

I'm working on a forecast follow-up-tool. Unfortunately I must be some kind of query-idiot.

This is my query result untill now.


My Query(design) untill now (parted)
[URL=http://allyoucanupload.webshots.com/v/2003257980184313873]

[URL=http://allyoucanupload.webshots.com/v/2003255496080630971]

What I would like to see is this: Every Cargonumber has a Month_of_Creation. All Months_of_creation must be displayed for each cargonumber in the query. Now the query only shows the cargonumbers where Month_of_creation=Order_Month Where Order_month isn't empty.


Any ideas how I should adapt my design-query?

Thanks.

 

[djayam]

Sorry mate but not being in English doesn't help! Maybe post the SQL in this thread?