RE: Developing Form For Sales Analysis
- From: "JimS" <JimS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Sep 2005 14:35:14 -0700
Ken,
I know you worked very hard to detail exactly what you want, and you can't
understand how anyone would have any questions, or misunderstand your intent,
but I would assume any advice I got on a forum like this is well-intentioned
and that any response, rather than being "ridiculous" is actually due to a
misunderstanding of some sort...
That said, I have a couple of questions...
If it's June, I'll only have 6 or so "buckets" for current year sales...do
you want to display 12 rolling months, or show zero's or blanks for the
months that have not yet occurred?
"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'm fascinated by your description. Sounds like a typical problem I face
day-to-day. If you want to email me your screenshot, I'd like to experiment.
Do you use a crosstab query as the basis for the form? What is the
recordsource for the form? If you use the table itself as the recordsource,
it's bound to cycle through all the records. If you only want to cycle
through the unique part numbers, you'll want to use an aggregating query as
the form's recordsource. That's probably what's causing you the heartburn...
--
Jim
"kennyharrill" wrote:
> 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
.
- Follow-Ups:
- RE: Developing Form For Sales Analysis
- From: kennyharrill
- RE: Developing Form For Sales Analysis
- Prev by Date: RE: Display combo box list without cursor click
- Next by Date: RE: Requery and apply filter
- Previous by thread: Re: Clearing fields in a query using a "CLEAR" button
- Next by thread: RE: Developing Form For Sales Analysis
- Index(es):
Relevant Pages
|
