Re: Cross Table
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 11/10/04
- Next message: atip: "Column prefix dbo.x does not match with a table... Error"
- Previous message: Joe Williams: "Date Criteria Question"
- In reply to: Lina Manjarres: "Re: Cross Table"
- Next in thread: Lina Manjarres: "Re: Cross Table"
- Reply: Lina Manjarres: "Re: Cross Table"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Nov 2004 13:38:58 -0600
Crosstabs are not updateable so you will have to either enter in a different
format or use code to or other method to de-normalize and then re-normalize.
Are you looking for code help? How many cities do you have? Does the number
of cities vary? Can you group your cities if you have too many? Would you be
satisfied with the spreadsheet appearance but needing to double-click an
entry to edit an individual value on a separate form?
-- Duane Hookom MS Access MVP -- "Lina Manjarres" <LinaManjarres@discussions.microsoft.com> wrote in message news:8F6F9EA3-1884-4EBE-9ECF-50BC41F51C78@microsoft.com... > Let's say my tables are like this: > > Table Cities: > ID_City > City_Name > > Table Products > ID_Product > ID_City > Product_Name > Price > > Any way, I just get a result like this: > > City_name Product_Name Price > MED Prod_1 $ > MAS Prod_2 $ > BOS Prod_3 $ > > And what I want to get is: > MED BOS MIA > Product_1 $ $ $ > Product_2 $ $ $ > Product_3 $ $ $ > > wher $ can be an input by the user. > > Thanks for all your help and your time. > > "Duane Hookom" wrote: > >> This helps but it wouldn't have taken too long to provide some actual >> field >> names and sample data. I assume you have done a good job of normalizing >> your >> tables but want to do your data entry in a "spreadsheet" type view. >> Crosstabs are not updateable so you will have to either enter in a >> different >> format or use code to or other method to de-normalize and then >> re-normalize. >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "Lina Manjarres" <LinaManjarres@discussions.microsoft.com> wrote in >> message >> news:510F871B-FE1D-4B59-A4E7-1753E8A2F53A@microsoft.com... >> > I have 2 tables, one for Cities, One for Products and prices. >> > What I need is to have a way to fill in the prices by product and by >> > city >> in >> > the format I outline before. If I have to change the design of the >> > tables, >> I >> > can do that, because I am just starting. >> > What I wish is to fill in the price of each product in each city, all >> > in >> the >> > same form. >> > Am I being clear? >> > >> > "Duane Hookom" wrote: >> > >> > > What specific problems are you having? We can't see your tables or >> > > forms >> or >> > > whatever. >> > > >> > > -- >> > > Duane Hookom >> > > MS Access MVP >> > > >> > > >> > > "Lina Manjarres" <LinaManjarres@discussions.microsoft.com> wrote in >> message >> > > news:0979CB8A-6ECC-42A3-AD7D-94F445FCD159@microsoft.com... >> > > > I need to make a query or a form that let me input data in this >> > > > form: >> > > > >> > > > City_1 City_2 City_3 City_4 >> > > > Product_1 $ $ $ $ >> > > > Product_2 $ $ $ $ >> > > > Product_3 $ $ $ $ >> > > > >> > > > Hope any body can help me! >> > > >> > > >> > > >> >> >>
- Next message: atip: "Column prefix dbo.x does not match with a table... Error"
- Previous message: Joe Williams: "Date Criteria Question"
- In reply to: Lina Manjarres: "Re: Cross Table"
- Next in thread: Lina Manjarres: "Re: Cross Table"
- Reply: Lina Manjarres: "Re: Cross Table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
