Alright so I am attempting to create a brochure style report for a tree nursery that lists the available prices of each plant, and shows the discount rate available for large purchases from 50 - 100 - 500+ and 1000+




What I would like is basically to see the data formatted like -

genus/species----common name----- type
abies amabilis pacific silver fir conifer

and then here have the dfferent types like
50 100 500 1000
seedling .50 .4 .3 .2
plugs 16in .50 .45 .4 .3



However, each of the specific types under a genus/species have a different productID, which is the primary key field. so when I try to format it I get repeating sections of the same genus/species

like this

abies amabilis pacific silver fir conifer
50 100 500 1000
seedling .50 .4 .3 .2

abies amabilis pacific silver fir conifer
50 100 500 1000
plugs 16in .50 .45 .4 .3




Whats the best way to combine all of the different productID's and price levels under just the species? Do I need to modify the query that the report is based off of? Can I do it simply in design view for the report? I'm a little bit stuck here, thanks.

Sometimes when you have complex data from a variety of different sources, it is simpler to create a new temporary table first using a Make Table Query followed by as many Append Query's as you need to get all the data in one place.

This temp table is then the basis for your report. The trick is to design the tmp tables so that it has all the data you need.