Need a grid (and need help!)

[CGC]

Hello,
I'm not sure where to start with this. I may need a report instead of a form, but I'm looking for suggestions. I have a price list (on paper) that we want to have in Access in the same format. (A table & a query are already set up.) The price sheet looks something like this:
Motor Speed Type
TypeA TypeB TypeC
motorA 100HP $100 $200 $300
200HP $150 $250 $350
motorB 100HP $500 $600 $700
200HP $650 $750 $850
You get the idea. By having it in Access we can update pricing (in the table or thru an update query) and have the price list updated at the same time. I won't need user input into the form (which is why I'm not sure if we need a form or report) but I'm not sure of how to set up this grid-type form to populate pricing in each grid based on the different motor types, speeds, etc. Any ideas on where I should start with this? Thanks alot!!

 

[pcs]

for certain, you'll want to use a report...

start by using the Report Wizard and try the various types of reports it generates...
you can then either modify one that comes close or look at the design in order to create your own.

hth,
al