Simple question - excluding a groupby

[theseandavis]

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

[Rich P]

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

[Bob Quintal]

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