Sum of numbers

[ftwguy]

Well I caved in with regret as I hate being defeated. I guess I take it too
personal that I failed. I did speak with the DB designer today, gave him an
overview of all the problems. He did say the Union All query would not fix
my report problem, but some 'scripting" would do it. I did explain the huge
tables to him and he agreed that it all needs to be redone, and knew exactly
the problems I am encountering. He said he could even write me a program to
automatically inmport sales data from Excel into the Access tables, and hit
every cell with the correct data, and ignore the ones that dont need data.
Now that I will be amazed by.

Don't know his fee yet. That's something between he and the boss, but I'll
hear what it is. I just warned the boss not to be too low in the contract
price and offend the guy with that much experience, education and
certifications.

 

[Evi]

You'll remember that much of your difficulty started because you weren't
allowed to re-design the database but had to work with it, as it is.
I suspect your chap will use a Make Table query at some point.
Oh to be a fly on the wall!
Evi