Hi,
Please be patient with me! I'm looking for the best way to structure a database. Here is a snapshot of a simple way to enter the data
Master Part # Competitor Name Competitor Price Competitor part #
123 Brand X 12.34 abc
123 Brand Y 8.85 xyz
456 Brand Y 12.86 def
456 Brand Z 7.34 fed
789 Brand X 7.95 qwerty
789 Brand Z 23.40 azerty
Ultimately, I want to be able to present the data under this format (Spreadsheet style) and export it to Excel.
Competitor X Competitor Y Competitor Z
Master Part # Part # Price Part # Price Part # Price
123 abc 12.34 XYZ 8.85
I'm opened to suggestions...
Should I simply structure the table the way I want the final result to look like?
Thanks
Add a unique identifier in your table as your primary key. It should be an autonumber. Set your table to resemble your input table as shown in your example.
To get the data to look like you want, you will need to build a cross tab query.
I would urge you to create a form for the input of data if this is something that you will distribute to users. If you already have the data in an excel sheet then you can import the data to table and run your cross tab query against the data.
Here is an example tutorial on building cross tab queries.
http://www.datapigtechnologies.com/f.../crosstab.html
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks