Pivot Table query field calculation

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Can anyone provide some assistance on how to build a
query from a pivot table?

I have a field called JCN that has none or some child
records. The field I'm trying to calculate is
called "Has Error" in both the parent and child. What I
need it to do is look at the "Has Error" fields and if
all are "error corrected" give me a value of one. If not
corrected then 0.
 
Hi,


I doubt you can... since the result is clearly not a table in the SQL
meaning of that word, as far I know. Better trying with a crosstab. That is
one of the few advantages of crosstabs over pivot tables, you can embed them
in your SQL.


Hoping it may help,
Vanderghast, Access MVP
 
Thanks for the reply.
-----Original Message-----
Hi,


I doubt you can... since the result is clearly not a table in the SQL
meaning of that word, as far I know. Better trying with a crosstab. That is
one of the few advantages of crosstabs over pivot tables, you can embed them
in your SQL.


Hoping it may help,
Vanderghast, Access MVP




.
Click to expand...
 
Back
Top