...new to Access........HELP!

[WhytheQ]

...someone will be able to help I'm sure (just whether you can be
bothered with something so trivial)

I have a DB that has 3 table: one of which is called "Financial Data" -
it has 7 fields: 3 of which are 'Income','Payouts','Users' ... these
are all Data Type Number.

There are 170k records and all I want is a quick way of looking at the
sum of each of the above mentioned fields. (also the max pf each would
be nice): do I use a report or a query (I'd quite like to get hold of
the answers in Excel so I have a feeling that a query is more useful.

Any help greatly appreciated.
Jason.

 

[Nick 'The database Guy']

Hi Whythe,

A query is the way to go if you want to cut and paste the data from
access to excel, if you want to do it properly the you will have to get
involved in VBA and I probably would not recommend that if you are a
real newbie.

Good luck

Nick

 

[WhytheQ]

if you've got an extract of code then hit me with it Nick. I've been
using the Excel vba model for nearly 4 years now, so even though I
unfamiliar with the Access object model I'm pretty familiar with the
structure of vba code. Although maybe setting up a query and then just
using "Get External Data..." in Excel and pointing it at the database
query would be the best way: unless you have reservations about using
this method??

any help greatly appreciated
Jason.