Search results

  1. D

    Field Update using DSUM: Field joins are not working correctly

    hmmm, now the values are null. actually, does anyone know if query results can be joined to like views? i.e. Update <table> inner join <query> on .... this may be a better solution for my problem. i tried it and it didn't work for me, but i may have gotten the syntax incorrect.
  2. D

    Field Update using DSUM: Field joins are not working correctly

    I know there are numerous threads regarding dsum() on the forum, but I wasn't able to find the exact answer to my problem. The root of my problem is that I'm trying to update a field on a table using dsum, which references another query to update the table. Although I have all of the correct...
  3. D

    INSERT INTO with summation and DSUM difficulties

    hello all, i stumbled upon this site via google while i was trying to find a solution to my problems! i'm a pretty proficient pl/sql writer and this is my first time trying to learn jet sql so a lot of the things i'm used to in pl/sql can't be done in jet sql! 1) i'm trying to create a...
Back
Top Bottom