Harlan Grove wrote:
wrote...
...
I CAN MAKE THE SAME NUMBERS YOU CAN. FASTER.
OK, I'll make this simple for you. Here's a table representing a 4x4
matrix. Show us, Oh Great Database Sage, the DBMS steps you'd take to
calculate its determinant and inverse. [Treat sequences of spaces and
underscores as field separators, but ignore the leading ones.]
Fld1__Fld2__Fld3__Fld4
-7__ -24___ -59___ 58
-78__ 65___ 56___ 22
59__ -60___ -31___ 47
35__ -21___ 10____ 1
Something tells me 99.999% of *rational* Access users would perform
this task by creating an Excel application instance and using its
WorksheetFunction.MInverse and WorksheetFunction.MDeterm to perform
these calculations, but I'm asking you to see how one irrational Access
user would do it.
are you challenging me?
...
Dunno about the other respondent, but I am. See the challenge above.
See my previous challenge to which you never responded (link below).
For a change of pace, quit talking out your backside and PUT UP OR SHUT
UP.
--- snip a bunch of stuff ---
Aaron,
If you can, please show how you would do Harlan's latest challenge in
Access. Please do not resort to some generality like you would use MDX
through Access. Stick to Access and give step by step details. No
broad overview, provide a specific answer.
Other posters who claim as much as you do are held to the same
standards. Just saying you can do this or do that does not make it so.
Please prove your competence with data analysis in Access, which
*you* claim.
Ignore the Excel angle. Please do not even consider it in your reply.
I would like to know how to do it in Access alone.
I do not care how long you have been working on whatever projects and
you can dispense with the preamble rants about anything and everything
Excel (Do you think it is a disease?) You need not worry if I produce
the same report every week. Just answer the challenge from Harlan.
Thanks,
Jay