Cross Tab Query Data Entry

  • Thread starter Thread starter AccessIlliterate
  • Start date Start date
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,
 
Do I need to register to be able to watch the demo? My company's firewall
won't let me register.
 
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?
 
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?
Click to expand...

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.
 
Back
Top