By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Simple question - excluding a groupby

P: n/a
Hello,

I am trying to sum together a number of rows by similarities that I
have grouped together with the pull down menu. I would like to exclude
one column if possible as it can be one of only two results and it is
most useful for me to not see a sum of results broken into those two
sections - I would rather see them all together.

Is there any way I can do this, or is it going to need to be mucking
around in the SQL?

Thx

Aug 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Greetings,

Your request is a little vauge because you haven't explained your
scenario in enough detail. But your quetions about "if you need to muck
around with sql" is a classic question for rdbms. Mucking around
(spaghetti code) is always an ALTERNATIVE solution. But whenever you
have to "Muck Arounnd/write spaghetti code" a red flag should pop up
immediately because that means that your database is not designed
correctly. It means that your database is not "Normalized" - you have
redundant columns, therefore, you have to hide them, do something with
them - "Muck around with the extra columns that you don't need/want".
The whole concept of database normalization is so that you can avoid
needing to write spaghetti code/ eliminate the need to "Muck around".
So, without knowing anything else about your system, I feel safe to
recommend that the solution is to normalize the database. But here is
the catch - Normalization is a complex subject and somewhat difficult to
grasp. This is the part that Microsoft leaves out in the Notes on its
"Ease of Use applications" like Access.

For simple/basic applications, normalization is usually not an issue.
But once you introduce one molecule of sophistication to your
application, if your DB is not propertly normalized, get ready to write
a ton of spaghetti code. It is doable, but not fun. I am still weaning
myself off of spaghetti code. It takes time.

HTH
Rich

*** Sent via Developersdex http://www.developersdex.com ***
Aug 14 '06 #2

P: n/a
th**********@gmail.com wrote in
news:11**********************@h48g2000cwc.googlegr oups.com:
Hello,

I am trying to sum together a number of rows by similarities
that I have grouped together with the pull down menu. I would
like to exclude one column if possible as it can be one of
only two results and it is most useful for me to not see a sum
of results broken into those two sections - I would rather see
them all together.

Is there any way I can do this, or is it going to need to be
mucking around in the SQL?

Thx
Are you asking "How do I delete a column from a query definition?"
Just go into the query design grid, hilight the column by clicking
in the band just above its name and {del}ete it.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.