Find mindste pris/værdi samt tilhørende varenummer

Opret en tabel med alle leverandører og send data fra dine leverandører ind i den. Derefter en forespørgsel der joiner leverandørerne.

isnt this the same question you have open here?
http://www.eksperten.dk/spm/757238

You can close the previous questioj by placing an answer and accepting it yourself, that way you get your points back too :o)

As far as I can see this is a mnay to many relationship so you should have three table.
You might only have 3 suppliers at the moment but you could get other later and that would require alterations to your current tables.

One table for "vare"
Varenr
VareText
.
.

One Table for "leverandøre"
LevNr
LevNavn
.
.

One table for "Leverandøre priser"
VareNr
LevNr
Pris
.
.

Then it should be quite simple to make a query which will give you what you want. It will also allow you to add new suppliers without further changes to the tables.
You could also add a date field to the "Leverandøre priser" table so that you can find the newest price, unless of course you only want to have only the last price.

Du kan sikkert lave det nemmere, men her er en løsning ved hjælp af 3 forespørgsler:

AllePriser:
SELECT KrydsTab.MitVareNr, LevA.VareNr, LevA.Pris, "A" AS Lev
FROM KrydsTab INNER JOIN LevA ON KrydsTab.LevA = LevA.VareNr
GROUP BY KrydsTab.MitVareNr, LevA.VareNr, LevA.Pris, "A"
UNION
SELECT KrydsTab.MitVareNr, LevB.VareNr, LevB.Pris, "B" AS Lev
FROM KrydsTab INNER JOIN LevB ON KrydsTab.LevB = LevB.VareNr
GROUP BY KrydsTab.MitVareNr, LevB.VareNr, LevB.Pris, "B"
UNION SELECT KrydsTab.MitVareNr, LevC.VareNr, LevC.Pris, "C" AS Lev
FROM KrydsTab INNER JOIN LevC ON KrydsTab.LevC = LevC.VareNr
GROUP BY KrydsTab.MitVareNr, LevC.VareNr, LevC.Pris, "C";

MindstePriser:
SELECT AllePriser.MitVareNr, Min(AllePriser.Pris) AS MinOfPris
FROM AllePriser
GROUP BY AllePriser.MitVareNr;

Resultat:
SELECT AllePriser.MitVareNr, AllePriser.VareNr, AllePriser.Pris, AllePriser.Lev
FROM AllePriser INNER JOIN MindstePriser ON (AllePriser.Pris=MindstePriser.MinOfPris) AND (AllePriser.MitVareNr=MindstePriser.MitVareNr);

!~)

P.s. mine tabeller:

KrydsTab:
MitVareNr
LevA
LevB
LevC

LevA:
VareNr
Pris

LevB:
VareNr
Pris

LevC:
VareNr
Pris