Crosstab&parameters

[finberg]

I am trying to make the crosstab query, which would be showing for each partner such table:
The list of books, the dates of orders and the numbers of the sertain book ordered.
When in constructor i ad the field Orderer and give the exact value- everething is going ok, but when in the field i enter [] For the request of the number of orderer, it gives me the error message "[] Couldn`t be recognized by the Mcirosoft Jet" What could it be?
And also I would like to use this query in the report.How can I make it (the dates of orders differs for each orderer.Thank you for your help



TRANSFORM Count([ShopsQ].Number) AS [Count-Number]
SELECT [ShopsQ].[Bookkode], [ShopsQ].Author, [ShopsQ].Name, Count([ShopsQ].Number) AS [Total Number]
FROM [ShopsQ]
GROUP BY [ShopsQ].[Bookkode], [ShopsQ].Author, [ShopsQ].Name
PIVOT Format([QDate],"Short Date"

 

[JerryDennison]

Try adding a prompt to the []'s

Like [Enter Number] "Advice is a dangerous gift, even from the wise to the wise, for all course may run ill." J.R.R. Tolkien

 

[finberg]

Unfortunately no way, but thanks for advice.
Arseniy

 

[JerryDennison]

What do you mean by "no way"? "Advice is a dangerous gift, even from the wise to the wise, for all course may run ill." J.R.R. Tolkien