Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2005, 08:49 AM
kennyharrill kennyharrill is offline
Novice
Microsoft Access - Form For Sales Analysis
 
Join Date: Sep 2005
Posts: 1
kennyharrill is on a distinguished road
Default Microsoft Access - Form For Sales Analysis

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM
Contact Form Help, Please. EISENHEIM Outlook 0 08-22-2008 06:54 AM
Microsoft calendar 6 pljames Misc 0 05-31-2008 05:33 PM
Microsoft Access - Form For Sales Analysis Microsoft Frontpage sufi Office 2 10-29-2005 07:56 PM
Microsoft Access - Form For Sales Analysis Source Doc - Microsoft Access 2000 Chamark Office 1 09-14-2005 05:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft