Cross Tab Query Data Entry

[AccessIlliterate]

I have created a cross tab query to show Clients as the rows and Job position
as the columns. The data in the query are the employees that work for each
client and their position. (thus easily showing the team for each client) I
would like to use this query to change the data. If Bob is no longer the
Team leader for this client, I would like to be able to switch this easily.
The problem is that the query does not let me modify the data. Is there a
better way to accomplish what I am trying to do?
Thank you,

 

[Banana]

Well, the crosstab query is non-updatable by definition. Assuming your
tables are properly normalized, you could take a look at the demo I
wrote some time ago demonstrating entry form in a spreadsheet-like fashion.

(watch out for broken link due to wraparound)
http://www.utteraccess.com/forums/s...123446&Zd=l&Zn=&Zt=18&Zs=&Zy=#Post1760936&Zp=

 

[AccessIlliterate]

Do I need to register to be able to watch the demo? My company's firewall
won't let me register.

 

[Banana]

Ooo, I forgot you have to register to download the demo. It's an actual
..mdb. If your company firewall won't let you download anything, then I
guess there's not much I can do.

But if you can download, it's mirrored at other forum I frequent. I'm
fairly sure you can download without having to register.

http://access-programmers.co.uk/forums/showthread.php?t=162765

 

[AccessIlliterate]

Thanks Banana,

I was able to download the database. Haven't quite figured out yet how you
did what you did but I think it will work for what I am trying to do.

Instead of check boxes, can those be combo boxes of staff names?

 

[Banana]

Thanks Banana,

I was able to download the database. Haven't quite figured out yet how you
did what you did but I think it will work for what I am trying to do.

Instead of check boxes, can those be combo boxes of staff names?

Basically the concept is that I create a temporary table based on the
result of crosstab query and assign query columns dynamically to the
form's columns and perform updates/insertions to the underlying tables
based on controls' AfterUpdate event.

Yes, you can use comboboxes instead of checkboxes if you want to. The
only condition is that there are exactly one intersection between each
row and column. Recall that crosstab query technically is an aggregate
query, so if the underlying tables allowed multiple intersections, the
results will be undefined.