If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Group By Desing View
I am running a query that I created in design view. I am linking a number of
tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the Values and Group By Account. On the Design view in the Total I choose Sum for the Value field and Group By for the Account field. But it does not group anything. It diplsays all entries that the query produces. Is this becuase I have other non-displayed fields in my query? Is there a way to do this? Thanks |
#2
|
|||
|
|||
Group By Desing View
Cluckers -
What you are suggesting should work. Post your SQL here so we can take a look and help you figure it out. (Go to View SQL and copy/paste the SQL statement here). -- Daryl S "cluckers" wrote: I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the Values and Group By Account. On the Design view in the Total I choose Sum for the Value field and Group By for the Account field. But it does not group anything. It diplsays all entries that the query produces. Is this becuase I have other non-displayed fields in my query? Is there a way to do this? Thanks |
#3
|
|||
|
|||
Group By Desing View
The GROUP is made over all the fields with the GROUP BY selection in the
graphical designer (or all those which appears in the GROUP BY clause in SQL view). Be sure to remove from the grid all other fields/expressions other than the field Account, with GROUP BY selected. Since Value has SUM, not GROUP BY, you keep it too. Vanderghast, Access MVP "cluckers" wrote in message ... I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the Values and Group By Account. On the Design view in the Total I choose Sum for the Value field and Group By for the Account field. But it does not group anything. It diplsays all entries that the query produces. Is this becuase I have other non-displayed fields in my query? Is there a way to do this? Thanks |
#4
|
|||
|
|||
Group By Desing View
The problem is I use the other fields to filter the records that I want. If
I remove the other fields how do I use them to filter the records? "vanderghast" wrote: The GROUP is made over all the fields with the GROUP BY selection in the graphical designer (or all those which appears in the GROUP BY clause in SQL view). Be sure to remove from the grid all other fields/expressions other than the field Account, with GROUP BY selected. Since Value has SUM, not GROUP BY, you keep it too. Vanderghast, Access MVP "cluckers" wrote in message ... I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the Values and Group By Account. On the Design view in the Total I choose Sum for the Value field and Group By for the Account field. But it does not group anything. It diplsays all entries that the query produces. Is this becuase I have other non-displayed fields in my query? Is there a way to do this? Thanks |
#5
|
|||
|
|||
Group By Desing View
You change the GROUP BY to WHERE, in the graphical designer.
Vanderghast, Access MVP "cluckers" wrote in message news The problem is I use the other fields to filter the records that I want. If I remove the other fields how do I use them to filter the records? "vanderghast" wrote: The GROUP is made over all the fields with the GROUP BY selection in the graphical designer (or all those which appears in the GROUP BY clause in SQL view). Be sure to remove from the grid all other fields/expressions other than the field Account, with GROUP BY selected. Since Value has SUM, not GROUP BY, you keep it too. Vanderghast, Access MVP "cluckers" wrote in message ... I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the Values and Group By Account. On the Design view in the Total I choose Sum for the Value field and Group By for the Account field. But it does not group anything. It diplsays all entries that the query produces. Is this becuase I have other non-displayed fields in my query? Is there a way to do this? Thanks |
Thread Tools | |
Display Modes | |
|
|