DSum Function

  • Thread starter Thread starter Fisico01
  • Start date Start date
F

Fisico01

Ok I am a total newbie with Access. Basically, I am dumping a hug
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. I
excel I would just use a sumif function to sum by the branch. I hav
no idea how I will be able to do this in Access. This is only half o
the problem. Once I figure out how to generate my totals, I will hav
to figure out a way to pull my total by branch over to my exce
spreadsheet. I have very little knoweldge of code so if you send m
some SQL code I may not understand how to implement your idea. An
help would be great
 
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,
 
Back
Top