Re: Vlookup nightmare

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

i can do a distinct(count) in Access about 100 different ways...
first off i could do a subquery--

flexibility of spreadsheets isn't all glamorous-- and im more flexible
with Access than you are with Excel.. i mean-- i build something that
works week in and week out.. and you build something that you have to
change every week

you call that flexibility?

but the real meat and bones for count(distinct) is doing this through
either SQL Server (again, MSDE-- freeware SQL Server is FREE with
Access license) and i could do that in ADP without even batting an eye.

If i was really hard-pressed to do this against a billion records; i
could do this in Analysis Services in my sleep..

and i wont crap out when i hit 64k rows lol

what a joke of a product.. i mean-- come on.. 64k rows; what the heck
am i supposed to do with 64k rows?

.

Quantcast