Third parameter asked for (1 Viewer)

MadeCurler

enthusiastic pensioner
Local time
Today, 22:16
Joined
Dec 6, 2007
Messages
49
I created a query to extract data from a table (called ClientDetails) based on the criteria - "Between [Start Date] and [End Date]". The query runs successfully. I then created a report based on this query but when I run the report after being asked for "Start Date" and "End Date" I'm asked for a third parameter - "ClientDetails.ClientID". Can anyone help please?
 

MadeCurler

enthusiastic pensioner
Local time
Today, 22:16
Joined
Dec 6, 2007
Messages
49
Solved. In the Properties Sheet of the report there was an "Order by" ..ClientDetails.ClientID...when I removed that the report works fine.
 

Users who are viewing this thread

Top Bottom