Recent content by ddohnggo

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.

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...

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...