Pivot Table From Simple Query

C

carl

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 ?
 
C

carl

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

Brendan Reynolds

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

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)


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

Filter2 ClientId: ClientId

Brendan Reynolds said:
Perhaps if you post the SQL, someone might be able to see what the
problem
is.
Click to expand...
Click to expand...
 
Top