Filter i en Forespørgsel

Du sikre dig det ved at bruge GROUP BY med Max på dit ID felt, som jeg antager er et fortløbende nummer?

SELECT Max(t.ID) AS MaxOfID, t.Fra, t.Til, Last(t.Pris) AS LastOfPris, Last(t.Dato) AS LastOfDato
FROM t
GROUP BY t.Fra, t.Til;

hej
mit Id felt er fortløbende
hvor sætter jeg ovenstående ind ?

Kan jeg se din forespørgsel?

Gerne - men hvordan ?

SELECT Data.DataID, Data.Date, City.City, City.Country, City_1.City, City_1.Country, Data.PriceAllInclEUR, Forwarder.Forwarder, [Shipping Person].ShippingPerson, Data.PiceNote
FROM City AS City_1 INNER JOIN (City INNER JOIN ((Data INNER JOIN Forwarder ON Data.ForwarderID = Forwarder.ForwarderID) INNER JOIN [Shipping Person] ON Data.ShippingPersonID = [Shipping Person].ShippingPersonID) ON City.CityID = Data.LoadingCity) ON City_1.CityID = Data.DeliveryCity;

Jeg antager at Data.DataID er dit ID felt :-)

Data.PiceNote må være din pris

Data.Date må være din dato som du henviste til?

Men hvad er "Fra" og "Til"  ???

"Fra, Til, Pris og Dato. Hvis jeg får en ny pris, hvor fra og til er det samme"

Looking at the sql #6 I'm guessing that although fra and til might be the same, other fields will not. So GROUPing isn't going to work :-(

and as dragnor asks, "hvad er "Fra" og "Til"  ??? "

City.City, City.Country = fra
City_1.City, City_1.Country = til
det er samme tabel, brugt  gange

Any chance of getting a copy of the dB?
ekspertenATsanthell.dk
AT = @

Hello Terry
its on the way
B.r.
Per

;-)

DataID    Date    City.City    City.Country    City_1.City    City_1.Country    PriceAllInclEUR    Forwarder    ShippingPerson    PiceNote
60    24/11/2016    Alba    Romania    Novi Sad    Serbia    850    Quattro-sped    Malene Messersmith   
102    27/01/2017    Alba    Romania    Novi Sad    Serbia    850    Zaliv    Bo Koch   
101    27/01/2017    Alba    Romania    Novi Sad    Serbia    900    Ralu    Bo Koch   

This is an extract of the SQL you gave #6 showing data for Alva to Novi Sad. Taking the price for newest (highest DataID = 102) the price is 850. So you only want too see data for 102, not other records for  Alva to Novi Sad?

First make a query and give it a name, I've used qryGroupCity2City in example.
This query is only to find highest DataID.
SELECT Max(Data.DataID) AS MaxOfDataID, City.City, City.Country, City_1.City, City_1.Country
FROM City AS City_1 INNER JOIN (City INNER JOIN Data ON City.CityID = Data.LoadingCity) ON City_1.CityID = Data.DeliveryCity
GROUP BY City.City, City.Country, City_1.City, City_1.Country;

Now make a new query using this SQL to give you result

SELECT qryGroupCity2City.MaxOfDataID, qryGroupCity2City.City.City, qryGroupCity2City.City.Country, qryGroupCity2City.City_1.City, qryGroupCity2City.City_1.Country, Forwarder.Forwarder, [Shipping Person].ShippingPerson, Data.Date, Data.PriceAllInclEUR
FROM ((qryGroupCity2City INNER JOIN Data ON qryGroupCity2City.MaxOfDataID = Data.DataID) INNER JOIN Forwarder ON Data.ForwarderID = Forwarder.ForwarderID) INNER JOIN [Shipping Person] ON Data.ShippingPersonID = [Shipping Person].ShippingPersonID;

And in the result query you dont really need MaxOfDataID  :-)

It could all be done in one query but this is the easiest

Thanks. I think I forgot to add field Data.PiceNote