List problem in report

[Øystein Sund]

Hello!

I've got a problem with a query in a list in a report.

If I use this query:
SELECT TB_service_deler.Deler_ID, TB_service_deler.Pris FROM
TB_service_deler WHERE
(((TB_service_deler.Service_ID)=Reports!Service_rapp_no!ID));

The result is only the first post that matches the value from the object.

If I replace the object Reports!Service_rapp_no!ID with an actual ID
value like this:
SELECT TB_service_deler.Deler_ID, TB_service_deler.Pris FROM
TB_service_deler WHERE (((TB_service_deler.Service_ID)=56));

The result now is right. It shows all the posts with the service_ID with
the value of 56.


What can I do to this query to get it right?


I'd be most greatful for any help!


-
Øystein Sund