PC Review


Reply
Thread Tools Rate Thread

Averaging Numbers with totals

 
 
=?Utf-8?B?SW5xdWlyaW5nIE1pbmRz?=
Guest
Posts: n/a
 
      29th Dec 2005
Hello,

I have a database that we would enter $ amounts into a field and would
require other fields to calculate a breakdown average for specifc sections.
Basically we are entering Company budgets and would like to break down how
much each department would receive by a percentage from the original budget.
How would I go about doing this?
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      29th Dec 2005
Sounds like a ... spreadsheet! Why do you believe you need to do this in a
relational database?

Can you export your data to Excel and do the percentage calculations there?

Regards

Jeff Boyce
<Office/Access MVP>

"Inquiring Minds" <(E-Mail Removed)> wrote in
message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> Hello,
>
> I have a database that we would enter $ amounts into a field and would
> require other fields to calculate a breakdown average for specifc
> sections.
> Basically we are entering Company budgets and would like to break down how
> much each department would receive by a percentage from the original
> budget.
> How would I go about doing this?



 
Reply With Quote
 
=?Utf-8?B?SW5xdWlyaW5nIE1pbmRz?=
Guest
Posts: n/a
 
      29th Dec 2005
I am also posting the results on an .asp webpage.

"Jeff Boyce" wrote:

> Sounds like a ... spreadsheet! Why do you believe you need to do this in a
> relational database?
>
> Can you export your data to Excel and do the percentage calculations there?
>
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Inquiring Minds" <(E-Mail Removed)> wrote in
> message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> > Hello,
> >
> > I have a database that we would enter $ amounts into a field and would
> > require other fields to calculate a breakdown average for specifc
> > sections.
> > Basically we are entering Company budgets and would like to break down how
> > much each department would receive by a percentage from the original
> > budget.
> > How would I go about doing this?

>
>
>

 
Reply With Quote
 
=?Utf-8?B?UHJpbmNlc3NsZXl2YQ==?=
Guest
Posts: n/a
 
      29th Dec 2005
Sorry to sound dumb but is that the only way? Is their NOT a way to do it on
an access database?



"Inquiring Minds" wrote:

> I am also posting the results on an .asp webpage.
>
> "Jeff Boyce" wrote:
>
> > Sounds like a ... spreadsheet! Why do you believe you need to do this in a
> > relational database?
> >
> > Can you export your data to Excel and do the percentage calculations there?
> >
> > Regards
> >
> > Jeff Boyce
> > <Office/Access MVP>
> >
> > "Inquiring Minds" <(E-Mail Removed)> wrote in
> > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> > > Hello,
> > >
> > > I have a database that we would enter $ amounts into a field and would
> > > require other fields to calculate a breakdown average for specifc
> > > sections.
> > > Basically we are entering Company budgets and would like to break down how
> > > much each department would receive by a percentage from the original
> > > budget.
> > > How would I go about doing this?

> >
> >
> >

 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      29th Dec 2005
I wasn't suggesting that it cannot be done in Access. I was questioning why
this particular tool was chosen. From the limited description, I'm not sure
that carrying out calculations like those described require the horsepower
(and learning curve!) of Access.

If I'm understanding what was being asked, it seems a little like trying to
drive nails with a chainsaw...

--
Regards

Jeff Boyce
<Office/Access MVP>

"Princessleyva" <(E-Mail Removed)> wrote in message
news:992FDC79-B166-4EB2-9C23-(E-Mail Removed)...
> Sorry to sound dumb but is that the only way? Is their NOT a way to do it

on
> an access database?
>
>
>
> "Inquiring Minds" wrote:
>
> > I am also posting the results on an .asp webpage.
> >
> > "Jeff Boyce" wrote:
> >
> > > Sounds like a ... spreadsheet! Why do you believe you need to do this

in a
> > > relational database?
> > >
> > > Can you export your data to Excel and do the percentage calculations

there?
> > >
> > > Regards
> > >
> > > Jeff Boyce
> > > <Office/Access MVP>
> > >
> > > "Inquiring Minds" <(E-Mail Removed)> wrote in
> > > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> > > > Hello,
> > > >
> > > > I have a database that we would enter $ amounts into a field and

would
> > > > require other fields to calculate a breakdown average for specifc
> > > > sections.
> > > > Basically we are entering Company budgets and would like to break

down how
> > > > much each department would receive by a percentage from the original
> > > > budget.
> > > > How would I go about doing this?
> > >
> > >
> > >


 
Reply With Quote
 
=?Utf-8?B?SW5xdWlyaW5nIE1pbmRz?=
Guest
Posts: n/a
 
      29th Dec 2005
I'm sorry Jeff, but I didn't post this inquiry just to be instulted. If
anything I posted this request to see if I can be assisted by those who are
more experienced and knowledgable of the abilities of the application itself.
I didn't know that this newsgroup was only for those who are well versed in
coding or design of a database. Because if that were the case then everyone
here wouldn't have the need to post as everyone here should be smart enough,
as yourself, to figure it out on their own and you wouldn't have to reply to
those of us who are not as experienced. I will make sure that I NEVER use
this Newsgroup again as it sounds it is only for those who are "SMART" and
more "ADVANCED"

Thank you.

"Jeff Boyce" wrote:

> I wasn't suggesting that it cannot be done in Access. I was questioning why
> this particular tool was chosen. From the limited description, I'm not sure
> that carrying out calculations like those described require the horsepower
> (and learning curve!) of Access.
>
> If I'm understanding what was being asked, it seems a little like trying to
> drive nails with a chainsaw...
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Princessleyva" <(E-Mail Removed)> wrote in message
> news:992FDC79-B166-4EB2-9C23-(E-Mail Removed)...
> > Sorry to sound dumb but is that the only way? Is their NOT a way to do it

> on
> > an access database?
> >
> >
> >
> > "Inquiring Minds" wrote:
> >
> > > I am also posting the results on an .asp webpage.
> > >
> > > "Jeff Boyce" wrote:
> > >
> > > > Sounds like a ... spreadsheet! Why do you believe you need to do this

> in a
> > > > relational database?
> > > >
> > > > Can you export your data to Excel and do the percentage calculations

> there?
> > > >
> > > > Regards
> > > >
> > > > Jeff Boyce
> > > > <Office/Access MVP>
> > > >
> > > > "Inquiring Minds" <(E-Mail Removed)> wrote in
> > > > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> > > > > Hello,
> > > > >
> > > > > I have a database that we would enter $ amounts into a field and

> would
> > > > > require other fields to calculate a breakdown average for specifc
> > > > > sections.
> > > > > Basically we are entering Company budgets and would like to break

> down how
> > > > > much each department would receive by a percentage from the original
> > > > > budget.
> > > > > How would I go about doing this?
> > > >
> > > >
> > > >

>
>

 
Reply With Quote
 
=?Utf-8?B?UHJpbmNlc3NsZXl2YQ==?=
Guest
Posts: n/a
 
      29th Dec 2005
HERE HERE!!

Any other takers for us "DUMMIES?" Help is appriciated. I just want to make
a page that will total how many visits a client was seen in a peticular
month. Also what those days were? Anyone?

"Inquiring Minds" wrote:

> I'm sorry Jeff, but I didn't post this inquiry just to be instulted. If
> anything I posted this request to see if I can be assisted by those who are
> more experienced and knowledgable of the abilities of the application itself.
> I didn't know that this newsgroup was only for those who are well versed in
> coding or design of a database. Because if that were the case then everyone
> here wouldn't have the need to post as everyone here should be smart enough,
> as yourself, to figure it out on their own and you wouldn't have to reply to
> those of us who are not as experienced. I will make sure that I NEVER use
> this Newsgroup again as it sounds it is only for those who are "SMART" and
> more "ADVANCED"
>
> Thank you.
>
> "Jeff Boyce" wrote:
>
> > I wasn't suggesting that it cannot be done in Access. I was questioning why
> > this particular tool was chosen. From the limited description, I'm not sure
> > that carrying out calculations like those described require the horsepower
> > (and learning curve!) of Access.
> >
> > If I'm understanding what was being asked, it seems a little like trying to
> > drive nails with a chainsaw...
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > <Office/Access MVP>
> >
> > "Princessleyva" <(E-Mail Removed)> wrote in message
> > news:992FDC79-B166-4EB2-9C23-(E-Mail Removed)...
> > > Sorry to sound dumb but is that the only way? Is their NOT a way to do it

> > on
> > > an access database?
> > >
> > >
> > >
> > > "Inquiring Minds" wrote:
> > >
> > > > I am also posting the results on an .asp webpage.
> > > >
> > > > "Jeff Boyce" wrote:
> > > >
> > > > > Sounds like a ... spreadsheet! Why do you believe you need to do this

> > in a
> > > > > relational database?
> > > > >
> > > > > Can you export your data to Excel and do the percentage calculations

> > there?
> > > > >
> > > > > Regards
> > > > >
> > > > > Jeff Boyce
> > > > > <Office/Access MVP>
> > > > >
> > > > > "Inquiring Minds" <(E-Mail Removed)> wrote in
> > > > > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> > > > > > Hello,
> > > > > >
> > > > > > I have a database that we would enter $ amounts into a field and

> > would
> > > > > > require other fields to calculate a breakdown average for specifc
> > > > > > sections.
> > > > > > Basically we are entering Company budgets and would like to break

> > down how
> > > > > > much each department would receive by a percentage from the original
> > > > > > budget.
> > > > > > How would I go about doing this?
> > > > >
> > > > >
> > > > >

> >
> >

 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      29th Dec 2005
My comments weren't intended as insults, and I apoligize if they came across
that way.

I asked because knowing how to do something doesn't make it the right thing
to do in every situation.

If you are only interested in "tell me how to do this, don't ask me why",
then I'd suggest you include that as part of your post. By all means,
re-post your question and let folks know what you're after. I'll step out
and let other folks respond.

If you are interested in having folks who read your post think about what
you've described and respond, then be willing to have folks ask for more
information. When I post questions in the 'groups, I expect to find out
something, maybe even things I didn't consider to start with.

Regards

Jeff Boyce
<Office/Access MVP>

"Inquiring Minds" <(E-Mail Removed)> wrote in
message news:C85EFAEE-E468-49D0-8D2A-(E-Mail Removed)...
> I'm sorry Jeff, but I didn't post this inquiry just to be instulted. If
> anything I posted this request to see if I can be assisted by those who
> are
> more experienced and knowledgable of the abilities of the application
> itself.
> I didn't know that this newsgroup was only for those who are well versed
> in
> coding or design of a database. Because if that were the case then
> everyone
> here wouldn't have the need to post as everyone here should be smart
> enough,
> as yourself, to figure it out on their own and you wouldn't have to reply
> to
> those of us who are not as experienced. I will make sure that I NEVER use
> this Newsgroup again as it sounds it is only for those who are "SMART"
> and
> more "ADVANCED"
>
> Thank you.
>
> "Jeff Boyce" wrote:
>
>> I wasn't suggesting that it cannot be done in Access. I was questioning
>> why
>> this particular tool was chosen. From the limited description, I'm not
>> sure
>> that carrying out calculations like those described require the
>> horsepower
>> (and learning curve!) of Access.
>>
>> If I'm understanding what was being asked, it seems a little like trying
>> to
>> drive nails with a chainsaw...
>>
>> --
>> Regards
>>
>> Jeff Boyce
>> <Office/Access MVP>
>>
>> "Princessleyva" <(E-Mail Removed)> wrote in
>> message
>> news:992FDC79-B166-4EB2-9C23-(E-Mail Removed)...
>> > Sorry to sound dumb but is that the only way? Is their NOT a way to do
>> > it

>> on
>> > an access database?
>> >
>> >
>> >
>> > "Inquiring Minds" wrote:
>> >
>> > > I am also posting the results on an .asp webpage.
>> > >
>> > > "Jeff Boyce" wrote:
>> > >
>> > > > Sounds like a ... spreadsheet! Why do you believe you need to do
>> > > > this

>> in a
>> > > > relational database?
>> > > >
>> > > > Can you export your data to Excel and do the percentage
>> > > > calculations

>> there?
>> > > >
>> > > > Regards
>> > > >
>> > > > Jeff Boyce
>> > > > <Office/Access MVP>
>> > > >
>> > > > "Inquiring Minds" <(E-Mail Removed)> wrote
>> > > > in
>> > > > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
>> > > > > Hello,
>> > > > >
>> > > > > I have a database that we would enter $ amounts into a field and

>> would
>> > > > > require other fields to calculate a breakdown average for specifc
>> > > > > sections.
>> > > > > Basically we are entering Company budgets and would like to break

>> down how
>> > > > > much each department would receive by a percentage from the
>> > > > > original
>> > > > > budget.
>> > > > > How would I go about doing this?
>> > > >
>> > > >
>> > > >

>>
>>



 
Reply With Quote
 
=?Utf-8?B?UHJpbmNlc3NsZXl2YQ==?=
Guest
Posts: n/a
 
      7th Jan 2006
Jeff you ot their??
Im still trying to drive these nails... You never were able to answer the Q
or did you???

Signed, DUMMIE

"Jeff Boyce" wrote:

> My comments weren't intended as insults, and I apoligize if they came across
> that way.
>
> I asked because knowing how to do something doesn't make it the right thing
> to do in every situation.
>
> If you are only interested in "tell me how to do this, don't ask me why",
> then I'd suggest you include that as part of your post. By all means,
> re-post your question and let folks know what you're after. I'll step out
> and let other folks respond.
>
> If you are interested in having folks who read your post think about what
> you've described and respond, then be willing to have folks ask for more
> information. When I post questions in the 'groups, I expect to find out
> something, maybe even things I didn't consider to start with.
>
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Inquiring Minds" <(E-Mail Removed)> wrote in
> message news:C85EFAEE-E468-49D0-8D2A-(E-Mail Removed)...
> > I'm sorry Jeff, but I didn't post this inquiry just to be instulted. If
> > anything I posted this request to see if I can be assisted by those who
> > are
> > more experienced and knowledgable of the abilities of the application
> > itself.
> > I didn't know that this newsgroup was only for those who are well versed
> > in
> > coding or design of a database. Because if that were the case then
> > everyone
> > here wouldn't have the need to post as everyone here should be smart
> > enough,
> > as yourself, to figure it out on their own and you wouldn't have to reply
> > to
> > those of us who are not as experienced. I will make sure that I NEVER use
> > this Newsgroup again as it sounds it is only for those who are "SMART"
> > and
> > more "ADVANCED"
> >
> > Thank you.
> >
> > "Jeff Boyce" wrote:
> >
> >> I wasn't suggesting that it cannot be done in Access. I was questioning
> >> why
> >> this particular tool was chosen. From the limited description, I'm not
> >> sure
> >> that carrying out calculations like those described require the
> >> horsepower
> >> (and learning curve!) of Access.
> >>
> >> If I'm understanding what was being asked, it seems a little like trying
> >> to
> >> drive nails with a chainsaw...
> >>
> >> --
> >> Regards
> >>
> >> Jeff Boyce
> >> <Office/Access MVP>
> >>
> >> "Princessleyva" <(E-Mail Removed)> wrote in
> >> message
> >> news:992FDC79-B166-4EB2-9C23-(E-Mail Removed)...
> >> > Sorry to sound dumb but is that the only way? Is their NOT a way to do
> >> > it
> >> on
> >> > an access database?
> >> >
> >> >
> >> >
> >> > "Inquiring Minds" wrote:
> >> >
> >> > > I am also posting the results on an .asp webpage.
> >> > >
> >> > > "Jeff Boyce" wrote:
> >> > >
> >> > > > Sounds like a ... spreadsheet! Why do you believe you need to do
> >> > > > this
> >> in a
> >> > > > relational database?
> >> > > >
> >> > > > Can you export your data to Excel and do the percentage
> >> > > > calculations
> >> there?
> >> > > >
> >> > > > Regards
> >> > > >
> >> > > > Jeff Boyce
> >> > > > <Office/Access MVP>
> >> > > >
> >> > > > "Inquiring Minds" <(E-Mail Removed)> wrote
> >> > > > in
> >> > > > message news:4938677D-C4C5-41CB-B075-(E-Mail Removed)...
> >> > > > > Hello,
> >> > > > >
> >> > > > > I have a database that we would enter $ amounts into a field and
> >> would
> >> > > > > require other fields to calculate a breakdown average for specifc
> >> > > > > sections.
> >> > > > > Basically we are entering Company budgets and would like to break
> >> down how
> >> > > > > much each department would receive by a percentage from the
> >> > > > > original
> >> > > > > budget.
> >> > > > > How would I go about doing this?
> >> > > >
> >> > > >
> >> > > >
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
averaging numbers Jeff@nospam.invalid Microsoft Excel Discussion 5 20th Jan 2011 08:38 PM
I've a series of dates i want grouped 2 use for averaging totals =?Utf-8?B?TW9v?= Microsoft Access Queries 3 26th Oct 2007 12:56 PM
Re: Averaging Numbers when 2 numbers in one cell =?Utf-8?B?T3VyYW5pYQ==?= Microsoft Excel Worksheet Functions 1 12th Jan 2005 06:40 PM
Averaging numbers Donduk Microsoft Excel Discussion 5 20th Dec 2004 12:18 AM
averaging weekday totals soph Microsoft Excel Worksheet Functions 4 16th Aug 2004 11:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:24 AM.