Re: DSum Function

To get totals by branch, use a Totals query, grouped by branch. If you
search Help for
Total records in a query
you should find instructions.

You can then export the query to Excel.

You can also use a Select query to return the records relating to a
single branch (or several branches).

On Tue, 26 Apr 2005 19:42:43 -0500,
denny.paganelli@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (Fisico01) wrote:

>Ok I am a total newbie with Access. Basically, I am dumping a huge
>csv file into Access because Excel is not able to handle the data.
>Ok to my question....I am trying to sum the total of "Extended Value"
>of a Product by Various "Branches" from my query that I set up. In
>excel I would just use a sumif function to sum by the branch. I have
>no idea how I will be able to do this in Access. This is only half of
>the problem. Once I figure out how to generate my totals, I will have
>to figure out a way to pull my total by branch over to my excel
>spread***. I have very little knoweldge of code so if you send me
>some SQL code I may not understand how to implement your idea. Any
>help would be great!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.