Report Troubles

[scottay]

First off, thanks to all who have helped me with my other posts

I have yet another question that y'all might be able to assist me with... I'm looking to create a report and am having trouble figuring out how exactly to format the stupid thing... And, like my other posts, this could be a little confusing... I'll do my best

I've modified this a bit to figure one thing out at a time. If you have a solution to my original post (below) feel free to help out, but for now I am just trying to figure out how to get the variables in the report to go across the page instead of down. I would like my quantity field to be listed across the page with the price for the part below it:

1-9 10-24 ... 50K+
$$ $$ $$

instead of:

1-9
$$

10-24
$$

...

50000+
$$

Thanks!


------ Here's my original post------
Ok, I've already got a query with all the data and computations needed. Basically I'm just trying to create a price sheet for our products here, but it's not quite that simple... I have 72 different part sizes, 12 for each of 6 voltages (3KV, 5KV...20KV), and a price for 13 different qty ranges (1-9, 10-24...50000+). I would like it to look something like this:

Qty1-9 Qty10-24 ... 50K+
Part 1 $$ $$ $$ $$
Part 2 $$ $$ $$ $$
Part 3 $$ $$ $$ $$
Part 4 $$ $$ $$ $$
Part 5 $$ $$ $$ $$
Part 6 $$ $$ $$ $$
Part 7 $$ $$ $$ $$
Part 8 $$ $$ $$ $$
Part 9 $$ $$ $$ $$
Part 10 $$ $$ $$ $$
Part 11 $$ $$ $$ $$
Part 12 $$ $$ $$ $$
...
Part 72 $$ $$ $$ $$

Parts 1-12 will be grouped by Voltage 1, Parts 13-24 by Voltage 2, and so on... Have I lost you yet?

Grouping by voltage can be left out for now if it add too much confusion...

 

[jfgambit]

I'm not sure how your tables are set-up, but have a look at the following sample database. It uses a pricing tale and pricelist type to resolve a Pricelist that can be exported or written into a report.

 

[scottay]

Thanks. I checked it out, but it didn't really answer any questions regarding reports.

Thank you for your reply