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.
Støv, fibre og metalliske partikler kan påvirke både uptime, levetid og driftssikkerhed. Derfor arbejder flere datacentre systematisk med contamination control.
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.
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?
Yes I understand danish but as your writing in English it isnt necessary :o)
I'll take a look at the dB ASAP
Synes godt om
Ny brugerNybegynder
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.
