Re: The best elegant solution to override 65k rows limit in a ***

harlan

you're friggin crazy.
get off your high horse.. small sums and easy math like that-- it's
easy to do on the database side.

and then you can centralize your logic in one place; and when you need
to change your calculation; you can do it all in one place.. instead of
wading through 1000 different XLS formulas.. I mean..

GAG ME WITH A SPOON

aren't you tired of having numbers that dont match?
the root of the problem with Excel is that you have different formulas
in each cell-- in Access you have a different formula for each COLUMN
(or field.. whatever nomenclature you choose)

I just know that there is a better way for all you guys to spend your
workdays.

Get this-- you can build a report and then run it each week
or you can build a report and then rebuild it each week.

Access allows you to go to huge datasets without a problem.
it just takes a little bit of work to get to know queries.

BFD, Excel was passe in 1992-- I mean-- it's time to lose the training
wheels kids

-aaron

.

Loading