Re: Summing totals if record satisfy criteria
- From: "Rudi" <Rudi@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Jul 2005 05:30:06 -0700
Here is what I have at the moment:
I have a form with 8 slots for the project name and 8 slots for the Hours
corresponding to each project slot. From these project slots, the user can
select any of the projects (from a drop-down list which uses another table
listing all of the possible projects). My form writes into the final table
for which I have at the moment, a field for every project slot and a field
for all the corresponding project hours.
What do have to need to change? Should I only have one project field and one
hours field named "Projects" and "Hours" in my final table respectively and
somehow connect it to another table? And how would I get the hours to
correspond with a certain project chosen?
Thus, the user will have the option to choose a certain project for each
slot as well as the amount of hours on that project (on the form). At the
end, I would like to generate a report and sees how many hours was spent on
which project, irrelevant on which slots the selected which projects
(Sometimes a cetain project will be selected on the first slot, sometimes on
the second slot or sometimes on slot 1 and 3). What is important, is to know
how many hours was spent on a certain project. The hours must correspond with
the spesific project and I would like to sum these hours for each project at
the end or something similar.
Thanks!
"Duane Hookom" wrote:
> It sounds like you need to normalize your table structure. However, we don't
> know what your structure is or how to help you unless you provide us with
> some sample data (with field names) and the desired sums.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Rudi" <Rudi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:AD232C6D-B500-4497-B221-A749ABA00EDD@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > I have a query that displays certain information based on a form. I now
> > want
> > to sum totals for certain information from the query. There is a few slot
> > for
> > projects. There is also about 10 projects to choose from. For each project
> > slot, there is a corresponding Hour slot. I can for instance select the
> > Blue
> > project in slot 1 and in slot 2 and the red project in slot 3 (this would
> > be
> > one record). At the next record I can choose Red project at slot 1, Blue
> > project at slot 2 and Green project at slot 3. At the end I want to add up
> > all the amount of hours for each project (never mind the slot that I have
> > chosen). Like, display blue project, 5 hours, green project 6 hours, Red
> > project 2 hours. What I basically need to do, is to count the amount of
> > hours
> > in a slot, based on certain criteria.
> >
> > How can I do this?
>
>
>
.
- Follow-Ups:
- Re: Summing totals if record satisfy criteria
- From: Duane Hookom
- Re: Summing totals if record satisfy criteria
- References:
- Summing totals if record satisfy criteria
- From: Rudi
- Re: Summing totals if record satisfy criteria
- From: Duane Hookom
- Summing totals if record satisfy criteria
- Prev by Date: Re: Summing totals if record satisfy criteria
- Next by Date: Re: Crosstab question
- Previous by thread: Re: Summing totals if record satisfy criteria
- Next by thread: Re: Summing totals if record satisfy criteria
- Index(es):
Relevant Pages
|
