Being prompted twice for same paramaters

[jonnycattt]

Hi all,
I've got a paramater query prompting me for 4 paramaters. The problem is that it prompts me for each of them two times. I've tried various combinations of parentheses, but to no avail.

Below is the query. Any ideas?

Thanks.

Marc

Here's the query:

SELECT PlantTOC.TOCID, Dockets.Month, Dockets.Year, Plant2002.Editorial, Plant2002.FirstAuthor, Plant2002.PrintPages, Plant2002.CM, DateDiff("d",Plant2002.FromEdOffice,(select ScheduleDate from Schedule_Master where EventTypeID=1 and Schedule_Master.DocketNumber = Plant2002.DocketNumber )) AS AvgVsDeadline, Plant2002.FromEdOffice, (select ScheduleDate from Schedule_Master where EventTypeID=1 and Schedule_Master.DocketNumber = Plant2002.DocketNumber ) AS ScheduleLastDay, (select ScheduleDate from Schedule_Master where EventTypeID=7 and Schedule_Master.DocketNumber = Plant2002.DocketNumber ) AS ScheduleMailDate
FROM PlantTOC RIGHT JOIN (Dockets INNER JOIN Plant2002 ON Dockets.DocketNumber = Plant2002.DocketNumber) ON PlantTOC.TOCID = Plant2002.TOCID

WHERE Dockets.Volume Between [Enter Start Volume] And [Enter End volume] AND Dockets.Issue Between [Enter Start issue] And [Enter End Issue] AND PlantTOC.TOCID<>21
ORDER BY Dockets.Year DESC , Dockets.Volume, Dockets.Issue, Plant2002.FromEdOffice DESC , Plant2002.CM;

 

[Mile-O]

It's prompting you twice because you are asking it to do so.

You would be better off to have these dates on a form and reference these dates within your query.

 

[jonnycattt]

Mile-O-Phile,
Where am I asking it to prompt me twice?

I have four paramaters, and so I should be prompted 4 times. Instead, I'm prompted 8 times.

Is this a result of all the joins?

Marc

 

[Mile-O]

Hi all,
I've got a paramater query prompting me for 4 paramaters. The problem is that it prompts me for each of them two times.

That's how I read it, 2 dates being asked twice making four parameters and not 8.

WHERE Dockets.Volume Between [Enter Start Volume] And [Enter End volume] AND Dockets.Issue Between [Enter Start issue] And [Enter End Issue] AND PlantTOC.TOCID<>21

And that's the four that I misread.

Sorry, I don't know what the problem is...