Query asking for parms twice *not due to sort, possibly bug* (1 Viewer)

[jtkjames]

Good morning all (at least, it's morning in the UK)

Not posted for a while, but I have hit a brick wall with my MDB developed in A2007.

I have a query, it's a Xtab which takes data from an Aggregated Select, which in turn takes data from a table.

The query is not sorted in datasheet view (nor are the subquery / table).

The query has the PARAMETERS sql correctly defined (see below)

The query when run from the list of modules only prompts for each parm once. But when it is executed from a form button, it prompts twice :S

I can only determine this to be some sort of bug (?) but was wondering if I am missing something obvious.

SQL code:

PARAMETERS [Start Date (dd/mm/yyyy):] DateTime, [End Date (dd/mm/yyyy):] DateTime;
TRANSFORM Count(qryOscarCalls.Serial) AS CountOfSerial
SELECT qryOscarCalls.Topic, qryOscarCalls.Subtopic, Count(qryOscarCalls.Serial) AS [Total Calls]
FROM qryOscarCalls
WHERE (((qryOscarCalls.StartStamp) Between [Start Date (dd/mm/yyyy):] And [End Date (dd/mm/yyyy):]))
GROUP BY qryOscarCalls.Topic, qryOscarCalls.Subtopic
PIVOT qryOscarCalls.VertexID;

The above prompts once for each parm when run from the module list, but twice when executed from a button (the button does a DoCmd.OutputTo).

Any ideas? I can post the DB if required.

Thanks in advance

James

 

[jtkjames]

I've solved it, but I think this just points to it being a bug:

I saved it as an "Access 2000" format database rather than "2002-2003" [this is in A2007] and now when pressing a button it doesn't ask for them twice anymore.

Hopefully this might help someone out there!!!