Need a Grid-Type Report

[CGC]

Hi,
I originally posted this in the form forum, but it was suggested I go the report route for this. I am trying to duplicate, in access, a price list that is currently on paper. The data needed for this price list is in 3 tables, and I have a basic query set up to pull all necessary data together. So now my problem is formatting it correctly into a report that is set up like a grid.
Here the basic idea of how we want it to look:
Motor Speed TypeA TypeB TypeC
motorA 100HP $100 $200 $300
200HP $150 $250 $350
motorB 100HP $500 $600 $700
200HP $650 $750 $850
So I'll need some type of code, I would assume, to say if it's a motorA, 200HP speed, TypeB motor, populate this column with that price ($250). Anyone have any idea on where I should start with this? By the way, the reason we want this in Access is because the prices change frequently. This way we can run an update query and change all necessary prices and just rerun the
price list. I really appreciate any help!

 

[Pat Hartman]

You shouldn't need any code at all. Use the report wizard to build the report. Just choose a tabular style. You will then be able to choose from a number of different formats.

 

[CGC]

Sorry for my delayed response on this. I am still having problems and thought I could figure it out myself (wrong!). I probably should have explained this better the first time, but I think my problem is in the fact that all the info I need to create this grid-report is all in one field. The field, "Description", has all the info jumbled together in a long string of text. This line might read "324MotorA 11/2132/2123 TypeA l15 100HP". There is a separate field that has the price ($100 for the example used). So in this example, my $100 price should be showing in my grid-report where the Motor #A, 100HP, Type A all intersect. And all that info came from this description line. So if I just create a report from the query, I still need to do something to tell each price where to go in my grid based on pulling certain data out of the description line. Does this makes any sense at all? Thanks again!

 

[Pat Hartman]

Try restructuring the table to de-mush the data. It is NEVER correct to store multiple attributes in a single column. If you can't fix the problem permanently by restructuring the table, you'll need to de-mush the description column in a query. Good luck.