Avatar billede hilmer101 Nybegynder
28. september 2007 - 10:51 Der er 3 kommentarer

Forespørgsel hjælp

Hej,

I får den lige på engelsk....

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.
[URL=http://allyoucanupload.webshots.com/v/2003143911281666711]

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.
Avatar billede terry Ekspert
28. september 2007 - 11:28 #1
Not 100% sure what your after. In the query you filter on Month_of_creation=Order_Month, so if you want to see ALL Months of creation, even those where Month_of_creation <> Order_Month then just remove the filter.


Otherwise yif you dont get further input your welcome to send your db to ekspertenATsanthell.dk (AT = @) and I can maybe take a look when I get a bit of time.

And maybe some examples of what your after
Avatar billede hilmer101 Nybegynder
28. september 2007 - 11:46 #2
the problem is that my 'Actual_Order' & 'Alle_Forecast' tables are inadequate.

E.g. in 01-04-2007, cargonumber 070004 doesn't have a forecast - therefore there will be no data in the Alle_Forecast data, hence, if there is an order in 01-04-2007 this field will stay empty in the query.. I need my Query to establish this 'information'.. do u know what i mean?

I'll send u the database...

Thanks alot!

Do you understand Danish?
Avatar billede terry Ekspert
28. september 2007 - 12:02 #3
Yes I understand danish but as your writing in English it isnt necessary :o)

I'll take a look at the dB ASAP
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester