Paramter in query

[Eirik Eldorsen]

I've made a query which works fine. My problem is that Access ask for a
paramter value when I run the query, and I can't understand why.

The query:
SELECT Ordre.ID, Ordre.OpprettetDato, Sum(ViewOrdrelinjer.Subtotal) AS
Total, OrdreStatus.Navn AS Status, Kunder.Firma
FROM OrdreStatus INNER JOIN (Kunder INNER JOIN (Ordre INNER JOIN
ViewOrdrelinjer ON Ordre.ID = ViewOrdrelinjer.OrdreID) ON Kunder.ID =
Ordre.KundeID) ON OrdreStatus.ID = Ordre.StatusID
GROUP BY Ordre.ID, Ordre.OpprettetDato, Kunder.Firma, OrdreStatus.Navn,
Ordre.KundeID, Ordre.StatusID, OrdreStatuser.Navn;

The paramter that I have to type:
OrdreStatuser.Navn

What can I do to make Access NOT ask for a parameter value?
--
Eirik Eldorsen

[Eirik Eldorsen]

I found out what the problem was:
In the group by I used: OrdreStatuser.Navn, should have been
OrdreStatus.Navn

"Eirik Eldorsen" <ku*******@hotmail.com> skrev i melding
news:d8**********@services.kq.no...

I've made a query which works fine. My problem is that Access ask for a
paramter value when I run the query, and I can't understand why.

The query:
SELECT Ordre.ID, Ordre.OpprettetDato, Sum(ViewOrdrelinjer.Subtotal) AS
Total, OrdreStatus.Navn AS Status, Kunder.Firma
FROM OrdreStatus INNER JOIN (Kunder INNER JOIN (Ordre INNER JOIN
ViewOrdrelinjer ON Ordre.ID = ViewOrdrelinjer.OrdreID) ON Kunder.ID =
Ordre.KundeID) ON OrdreStatus.ID = Ordre.StatusID
GROUP BY Ordre.ID, Ordre.OpprettetDato, Kunder.Firma, OrdreStatus.Navn,
Ordre.KundeID, Ordre.StatusID, OrdreStatuser.Navn;

The paramter that I have to type:
OrdreStatuser.Navn

What can I do to make Access NOT ask for a parameter value?
--
Eirik Eldorsen