Results 1 to 2 of 2
Thread: Change displayed data
2001-01-17, 23:55 #1
- Join Date
- Jan 2001
- Santa Clara, California, USA
- Thanked 0 Times in 0 Posts
Change displayed data
Is there a way to change how data is displayed using query or report? The data is currently his way in the table:
ID, Name, City, Type
50, CarShop, Springfield, Home
50, CarShop, Springfield, Marine
50, CarShop, Springfield, Commerce
I would like it to be this way in a report:
ID, Name, City, Home, Marine, Air, Commerce
50, CarShop, Springfield, Home, Marine,,Commerce
I thought a crosstab would work, but I can't figure out how.
2001-08-17, 08:10 #2GiovanniGuest
Re: Change displayed data
This is a very nice example for bad database design without normalization.
In order to have the desired report you need to have two tables in 1-n relationship (referential integrity):
1. tblShop with Shop_ID, Shop_Category, Shop_City
2.tblType with Type_ID, type_ShopID, Type_Name
Do not forget to define the relationship in the relationship window and use the grouping options for the report.