By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Editing Data with Crosstab Queries

P: n/a
I have a table that I want to left join with crosstab query and I want
to be able to edit data in the table (only). However, once I perform
the join, the entire query result cannot be edited. Is there any way
to allow editing this (besides pushing the results into a table - I
want to avoid this due to concurrency issues)?

May 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Greg,

Here is a thought on crosstab queries - these queries display data in an
unormalized state - repeating columns of the same data types. This is
the intention of crosstab queries - for reporting purposes.

To join a table with a crosstab query defeats the purpose of using an
RDBMS. You may consider joining your table in question to the table(s)
that make up the datasource for the crosstab query - that is, create
relationships. Another alternative would be to create a temp repository
table that you could fill with data from the crosstab and the other
table.

This kind of scenario brings up the age old dispute between the efficacy
of Access vs Sql Server for advanced operations. Sql Server makes
crosstabbing (rotating data) very easy, but a lot of the functions of
Transact Sql are not supported in Access Jet sql. So you have to
compensate by using the workarounds that I suggest above for performing
similar operations in Access. For someone who is real proficient with
Jet Sql - it is possible to simulate some of (quite a bit actually) of
the functionality of Transact Sql, but it is usually simpler to just do
the workarounds.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
May 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.