Recent content by FatherNature

Thanks for all the help, I implemented Bob's solution and it worked flawlessly. The only tweak I had to throw in was to pass in start and stop indexes since there was some blank space at the end. Thank you for helping me get a better grip on DB programming, all of your help is very...

Thanks for all the help. I'll try to integrate the different solutions to see what works best and report back on Monday :) David

It's not a report, it's a dump to a binary file. That part is working (fortunately). I guess what I was hoping to use a VB query for is to create a table on the fly to UNION to. This would give me the flexibility to reuse the fix for other broken tables, improve the speed (currently it uses...

I have a tricky problem that I am trying to work around. I have a database that needs to create a datafile in a specific format. The keys are in a staggered array, and I need the query to generate the data with the gaps filled in, a simplified example follows: ID DATA 500 12 501 20 502 100 505...