wrote...
haha im not in a hole

Quite so. You *are* a hole, an metaphysical absence of anything
remotely associated with intellect. Then there are the holes in your
head, more and larger than those normal humans possess.

i can do this; i just have a fulltime job and a bunch of contracting
thigns on the side; and 3 kids to deal with at home.. i dont have a ton
of time to look into this; but i will try this weekend (in between
clients)

Excuses. I already gave you an out: start off by showing code which you
must *already* have to convert a table of, say, 4 records and 4 fields
of double precision floating point numbers into a VBA array perhaps
named SourceArray, then a stub function call like

ResultArray = MatrixInverseStillToBeWritten(SourceArray)

then create a new DBMS table from ResultArray. Someone who claims to be
such an expert at Access, DBMSs in general and VBA must have written
such procedures before. Do you lack access to the code?

You've claimed that you can do any calculations in Access or VBA that I
can do in Excel, and you've claimed you can do them faster. It seems
the only small chink in this edifice of calculation proficiency you've
proclaimed for yourself is writing the code needed to reinvent Excel's
existing functionality. So if you're as good at VBA as you've claimed
you are, but you can't provide a working solution after a whole week,
what chance would anyone who's never programmed in BASIC or any other
procedural or OO language have writing code to get Access to do what
Excel can do out of the box?

You don't see any defects in your arguments to date?!

i haven't ever had any math in the db world that is even challenging; i
mean.. sum this sum that

Yup. That's what databases are good at: summing, counting,
categorizing. They're not really meant for linear algegraic operations.
Neither is VBA. [If only Microsoft would add the MAT statements from
PowerBASIC or TrueBASIC.]

none of it is slightly challenging

i took 3 semesters of college calc 15 years ago; i know i can do this

Oh, certainly. Why anyone can write robust numerical code. They just
won't take as long as you seem to need.

All you need to do is translate existing code into VBA. However, since
you apparently don't know any other languages, and there's a dearth of
VB[A] matrix inversion routines on the web, you're screwed. So much for
VB[A] being the only language you need to know.

Wassa madda, you couldn't even figure out the BASICA code to which I
posted a link in

http://groups.google.com/group/micro...1e6c06cb50add0

?!

all i know is that subqueries and views and user-defined functions are
more powerful than copying and pasting formulas around.

For counting, summing and categorizing, sure. For inverting matrices or
generating all permutations of sets of distinct tokens, no way. No
single software tool or language is any more universally appropriate
for any & all applications than any single hand-held tool is
universally appropriate for any & all woodworking tasks. You know how
to use a hammer, and you think your hammer is a better saw,
screwdriver, drill, . . .

i know it and you guys are crazy for not seeing the light

The light you see is the train coming at you in the dark tunnel into
which you've blundered.