We are trying to develop a tool for us to be able to analyze the sales by quantity and dollar amount of our heat transfers and designs. The columns in our table are PARTCODE, SALEMONTH, SALEYEAR, SALEQTY, SALESALES, and URL. A typical row looks like this:

4173L, 1, 2005, 44, $550.00, www.mylink.com/images/lg/4311.jpg
(The one in the second column stands for January)

We are hoping to utliize an Access form (I can email a copy of a screenshot showing what we're hoping to accomplish to anyone who may be interested). We are wanting each page to display one image. There are 18 different controls that we would like showing up:

1. The total number of the transfer sold, by quantity, for year up to date.
2. Breakdowns of number sold by month (12 total) for the current year.
3. Totals sold by dollar amount for the current year and the previous four.

I've been able to get this to work - somewhat. The controls work fine; however, when I display the form in Form view, the navigation is showing all 423 records. In our sample table, we're using only two design numbers - thus, we're trying to get our form to show only two records. Eventually, we want to be able to gather information from a SQL Server database.

I sure would appreciate any help that anyone can give us. This has got us totally stumped. I was told in another forum to try adding subforms to the page. That's ridiculous because all it does is make the page crowded. We don't want one form with 18 crowding subforms. We want to be able to display just the actual numbers, actual results, and we hope that surely someone has developed something similar to this or can help us.

Again, if you would like for me to email a copy of the diagram, please let me know. Many thanks

Ken