Crosstab queries in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like base a form on a crosstab query and be able to change the
values. Is this possible?
 
I would like base a form on a crosstab query and be able to change the
values. Is this possible?
Click to expand...

No. A Crosstab query is an aggregate, so that any individual field in
it doesn't "belong" to any particular table.

You'll need to use either a temp table or an unbound form with code to
move the data into your normalized table.

John W. Vinson[MVP]
 
Back
Top