The query does run in access. I do not receive any errors in Access. The
query runs fine in Access.
When I use a pivot table in Excel the expression does not translate over to
give me the same totals.

"FSt1" wrote:

hi
does the query run in access? what errors are you getting?

Regards
FSt1

"nazzoli" wrote:

NORY: IIf([ATTY ID]=3042,"NAN",IIf([ATTY ID] Between 80 And 1500 Or [atty
id]<80 And[list date with attorney] Is Not Null Or [forward dte] Is Not Null
Or [status] Like "dis*" Or [status] Like "atty *" Or [status] Like "req*" Or
[status] Like "ban*" Or [STATUS] Like "DIM*" Or [STATUS] Like "JUD*" Or
[STATUS] Like "AT*" Or [status] Like "CL*" Or [status] Like "demand *" Or
[status] Like "served" Or [status] Like "wtg *","YGC"))

"FSt1" wrote:

hi
more info please.
if the access query has prompts for parameters on the access side, that may
be your problem.
post the access espression.

Regards
FSt1

"nazzoli" wrote:

I am running a pivot table in Excel off of an Access Query. The pivot table
is not recognizing the like expression I have built in Access. Any reason
why?