Quote:
Originally Posted by AOG123  Thanks Don,... the good news is my tables stucture is almost a replica of your example,.. so theres room for mods,.
It's a shame that the requirements are so specific,. but as it stands i have wrote a new ultra fast concat function which adds the concat to a temp table on the be.mdb ,.. leaving me the problem of the breakdown,.. which is in the last post. Which is required to update the original request table.
I really appreciate your time on this,.. and it must be quite irritating to others as it all seems a little odd.  |
Naa, not irritating at all, it's an interesting issue. Personally, I would avoid using any VBA function to accomplish that kind of processing and any temp tables. My opinion is based on the fact that database engines are marvelously efficient pieces of software when doing the work they're designed to do, FAR more efficient than any code that you or I could write. It's like writing your own bubble sort code instead of using finely tuned sorting functions built in to a language. Sure, it can be done. Sure, it works. But it is not the best use of the computer, or of the programmer's time. IMHO.
05-08-2008, 02:10 PM
Linear Mode
