A weird result-table

[studentapprentice]

Hi guys!

I got a Problem which i CANNOT solve at all. It´s :banghead: IMPOSSIBLE that it is working like that.


My code goes like this:
(Pseudo)

For every Test
For Every Parameter
Insert Into Table Values (AVG + Deviation) for Each Supplier
Next Parameter
Next Test

So... when i am Choosing in my Form more than 1 Parameters, it is likely to happen that my resulting table looks like that :

Test - Parameter - Result - Supplier1 - Supplier2
T1 - Para1 - Avg - 0.5 - 0.3
T1 - Para1 - Dev - 0.1 - 0.05
T2 - Para1 - Avg - 2 - 3
T2 - Para1 - Dev - 0.7 - 0.9
T2 - Para2 - Avg - 5 - 2
T2 - Para2 - Dev - 1 - 0.8
T1 - Para2 - Avg - 3 - 1
T1 - Para2 - Dev - 0.75 - 0.4

How is that even possible? I checked my Code in Debug-mode and he DOES insert it at the right place (recordset-position of Table where the values go into)

I mean, in the code it says explicitly Go through T1, then T2.

And i am sorry to say in advance but there is now query which would satisfy my needs. Its a complex setting and its taking much time but i can garantee a 100% correctness of my data going inside and outside the database

I do need it sorted, because that resulting table is going to be exported in a excelfile and i want (or better have to ) create an automated diagram.

Any advice would be helpfull, hoping not just having answers like "VBA is shit" that is coming to my mind right now

Thanks in advance,
Steve

 

[DJkarl]

Pseudo code in this case isn't all that helpful. If you can please post the actual VBA routine that is running, what you wrote in your pseudo code may not be what was actually coded.

 

[studentapprentice]

Well, i´ve checked it double-time and also my supervisor checked on the code and he could find any clue ( and the pseudocode nearly rly represents the real code )

Now i do it with a Query, sort it by Parameter, Year and Result and save it again into a Table ready for Export. Complicated but it´s working :/

Thanks anyway!