how do I add diffrent figures from aceess

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get all my sucseful sales amounts and then add them up into a total
for sub products and the total for all products any idea
 
pjwf said:
I want to get all my sucseful sales amounts and then add them up into
a total for sub products and the total for all products any idea
Click to expand...

You likely will want to use report, maybe teamed with a query.

You can filter the data from one or more tables (I believe your data
should be in more than one table if it is properly normalized) so you have
only successful sales listed. Then you can group the data by sub products
and total each sub project and have a grand total.

Note: I don't know how experienced you are with Access. It does have a
steep learning curve. The first few projects tend to take a while and may
be a little frustrating at first. You may want to take a look at the
Northwind example that comes with Access.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to ignore a column of numbers in Grand Total for rows 1
Aggregate Function Error 0
Excel Getting an annualized figure based on YTD in Excel 1
Adding two access fields together and saving the total into thetable. 4
Crosstab Qry-Add Rows & Columns 2
IIF statement not working 4
Date Calculations 1
How do I pull data off the hard drive I pulled from a dead Toshiba laptop? 19

Back
Top