Problem creating a query

E

erick-flores

hello all
I am trying to create a range date for my query and I am gettin the
following error:
"Parameters are not allowed for this query"
It looks like the parameters are not allowed when I am doing a query
for a PivoTable, because when I used the same parameters when building
just a Build-Query it will work just fine. This is what I have in the
criteria:
Criteria Field: Period Ending
Value: = [StartDate], [EndDate]

can somebody help me here, why why why this can not work when creating
a PivotTable?...its so frustrating
If this is not possible, Is there any way around to get a date range?

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivotable Parameters 1
Passing parameters to a Web Query 1
Query using date range entered by user 2
Google query 8
Userforms and Dates 1
SQL Syntax Error in Query 2
Parameter Query Won't Run 0
Date Range Query. Criteria based in a table. 4

Top