By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 696 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

Paramter in query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.