Crosstab query?

  • Thread starter Thread starter Sherrie
  • Start date Start date
S

Sherrie

I am trying to create either a form or query where I can
make data entry for each month or quarter $value end very
simple. Right now I have a table set up with the clients
name and another table containing the month or quarter end
values. I also need it group by company which is in my
clients table.

Can I do this with a crosstab query? I tried doing a
pivot table, and it is what I wanted, but it won't allow
me to data entry anything.

Any suggestions? Thanks!!
 
You can't do any data entry on group by or crosstab queries. There are ways
around this that generally involve unbound forms and/or a fair amount of
code.
 
Back
Top