Crosstab query?

[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!!

 

[Duane Hookom]

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.