Microsoft Access Question

[adempster1]

Access Question


--------------------------------------------------------------------------------



My task is running a report that tallies all entries made for a particular date. The problem isn’t creating a query to get all entries for a specific date, but tallying all of the entries.

Any Idea how I can tally all of the entries?

[pdxmotorhead]

Use MySql on a Linux machine and drop kick the MS product into the sea?

Bwahahahahahahahahah.....

Couldn't resist..

Dave

[monk3y666]

tally - like sum?

something like
SELECT SUM(nValue)
FROM tTable
WHERE ...
GROUP BY ..

etc

been a year since i touched access... now its sql server all the way

[adempster1]

thanks, I will toy around with it. I guess is time for me to drop access

[evalha007]

Export to Excel!

[monk3y666]

Originally Posted by adempster1

I guess is time for me to drop access

NO ! all databases have their uses - depends on the what you want to do with the data, how many people are using it etc

big scale corporate - Sql server

small to medium size Access/Foxpro/or small SQL server install

1 to 20 users or occasional use - Access (free with office!)

I work for a 2000+ employee company SQL server is used for the big order/shipping database - but as it's expensive - there are numerous access databases in various depts for their own uses (sickness, document management etc)

[pdxmotorhead]

You should have said all data bases not running on a windows machine ...... Have their uses....

Sorry I've been access road kill for the last month.

Dave