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

Where should I start?

P: 2
Hey Everyone ... First off, I'm very new to all this.

Im making a forecasting database for the sales team. I have two tables.

Table One: Part Information (Description, Status, Salesman, Company, etc.)
Table Two: Part Revenue (Part ID from Table One, Month, Year, Actual Revenue, Forecast Revenue)

The best way to explain it is that right now I run a CrossTab Query that displays the part description as the Row Heading, the Month as the Column Heading and the Forcecast Revenue as the Values.

This creates a nice page for the salesman. He see's the part and a text box for all 12 months of the year where he can update the forecast.

Problem: You can't update a CrossTab Query

Please help. Note: I am a newb.

Thanks

Eric
Jan 15 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,489
It's true : You can't update a CrossTab Query.
I'm afraid you've hit a showstopper for that idea. What sort of help are you looking for (other than to confirm that's a problem)?
Jan 16 '07 #2

P: 2
I'm basically looking for a work-around. To me this seems like a common way of designing a database.

How do I create a form that will allow me to do this?

Thank You
Jan 17 '07 #3

NeoPa
Expert Mod 15k+
P: 31,489
I'm pretty sure that any manipulation of the data to group items from multiple records so that they show in a single output record will cause difficulties with updating the returned recordset. Cross-Tab or aggregation (GROUP BY) queries are never updatable.
I can't think of a way to maintain the data without showing the items in their native form.
Jan 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.