PIVOT TABLE

  • Thread starter Thread starter nazzoli
  • Start date Start date
N

nazzoli

Here is the issue I am running in to when building a pivot table in Excel
2007 off of an Access Database Query.

I have a large text file that I import into Access 2007. I then build a
query to pull a certain set of results out of the text file. Within the
query I have built items to use the like expression.
I then am building a pivot table in Excel 2007 off of that query. However,
it appears that my Pivot table is not able to read the "Like" Expression.
Is there any reason for this?
 
Hi,

Is you Where clause in a query or in code. Can you show me the Where clause
so I can test.
 
Here is one example using it in an expression to populate fields:IIf([Ref #]
Like "*SOM*","SOM","Not SOM") AS [SOM?]

And here is one using a where clause
WHERE ((([BJEFOR].[DTE REF])>=#1/1/2007#) AND (([BJEFOR].[STATUS]) Like
"DIS*" Or ([BJEFOR].[STATUS]) Like "DI*"))

In both instances I am unable to build a pivot table in excel off of those
because the pivot table is bringing back 0 lines of data.
 
Hi,

I can't tell for sure but it looks like these clauses are located on the
server side? Not in Excel's VBA area? Or are they in MS Query?

I'm not even sure I understand the first one - in Excel I think we would
right the first one as Like "*SOM*"

I'm not sure what the additional arguments mean and I don't think Excel
would use them. What is it supposed to do?

Cheers,
Shane Devenshire

nazzoli said:
Here is one example using it in an expression to populate fields:IIf([Ref #]
Like "*SOM*","SOM","Not SOM") AS [SOM?]

And here is one using a where clause
WHERE ((([BJEFOR].[DTE REF])>=#1/1/2007#) AND (([BJEFOR].[STATUS]) Like
"DIS*" Or ([BJEFOR].[STATUS]) Like "DI*"))

In both instances I am unable to build a pivot table in excel off of those
because the pivot table is bringing back 0 lines of data.

ShaneDevenshire said:
Hi,

Is you Where clause in a query or in code. Can you show me the Where clause
so I can test.
Click to expand...
Click to expand...
 
Back
Top