?! Define "best expert" ?!
If either approach works quickly, and you can't measure "any significant
difference", the choice seems moot.
One definition of "expert" might be which generates the most "elegant"
solution.
Another might be which generates an accurate solution faster.
And yet another might be which approach solves the problem and allows me to
move on to the next issue. (?<g> can you guess which one I tend to use?!)
For me, it's often easier to find a working solution, move on, and come back
later if performance (or other considerations) become factors... (i.e., new
requirements/new issue)
--
Good luck
Jeff Boyce
<Access MVP>
Hallgeir said:
Jeff
Both of my solutions works fast. I can't measure any signifcant difference
in time. I was just wondering if there was any known "good practice" in such
case. Which one of my solutions would the best expert use.
Hallgeir
"... a lot of records" may mean something different to you than to me. A
well-normalized database, with (if appropriate) indexed fields will produce
a decent response time (?fast) for hundreds of thousands of rows. The
version of Access, the version of your OS, the "horsepower" of your PC, the
amount of RAM in your PC, whether or not this is a "split" database, with
data located on a network server, these are also all factors in "fast".
What happens when you try it the two different ways you mentioned?
--
Good luck
Jeff Boyce
<Access MVP>
or