Averaging Numbers with totals

[Guest]

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?

 

[Jeff Boyce]

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>

 

[Guest]

I am also posting the results on an .asp webpage.

 

[Guest]

Sorry to sound dumb but is that the only way? Is their NOT a way to do it on
an access database?

 

[Jeff Boyce]

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...

 

[Guest]

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.

 

[Guest]

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?

 

[Jeff Boyce]

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>

 

[Guest]

Jeff you ot their??
Im still trying to drive these nails... You never were able to answer the Q
or did you???

Signed, DUMMIE