|
Re: The best elegant solution to override 65k rows limit in a sheet
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
|