i need help on this project it really makes me crazy... imnising access 2007 and vb6 together in my code im trying to make a report using sql query inner join on access database with aggregate function so sad the result is really bad.... the many to many relation ship with aggregate function gives me the wrong result... Please give me any idea on this... thank you so much on advanced....

I can make a bet this may not work correctly. Long ago I had issues with VB6 and wrong answers. There were two causes.

  1. I forgot that a VB6 Integer was only 16 bits.
  2. There were patches made in VB6's SP6 and SP6a that corrected things.

Fast forward to today and I don't see these two apps working on Windows 10 or maybe others so it's a dead area to develop. I'm not surprised at all that it doesn't work.

If you are still having problems with this let me know.