Cross Tab Query Data Entry

A

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,
 
A

AccessIlliterate

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

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?
 
B

Banana

AccessIlliterate said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top