Pivot Table From Simple Query

[Guest]

I am running into a problem when I try to use the Pivot Table Wizard.

If my query has only 1 instruction, the wizard works.

When I add a 2nd instruction, the wizard returns an excel error message
"trouble obtaining data"

Any thoughts ?

 

[Brendan Reynolds]

What do you mean by 'instruction' in this context?

 

[Guest]

In this context, I have a query that filters between 2 times and for a
specific customer id.

 

[Brendan Reynolds]

Perhaps if you post the SQL, someone might be able to see what the problem
is.

 

[Guest]

Filter 1 TimeFilter:[Time] Between [Start] and [End]

Filter2 ClientId: ClientId

 

[Brendan Reynolds]

That's not SQL. To get at the SQL for a query, open the query in design
view, then choose SQL View from the View menu.

--
Brendan Reynolds (MVP)

Filter 1 TimeFilter:[Time] Between [Start] and [End]

Filter2 ClientId: ClientId

Perhaps if you post the SQL, someone might be able to see what the
problem
is.