Recently a client of mine made the move to Microsoft Access from a DOS based 
version of Corel Paradox -- and I've now inherited the task of converting the 
legacy code into Microsoft Access Queries and Macros.

Right now I've gotten most of the work done... the system I'm building is 
supposed to update mailing lists and customer records -- for example we'll 
have a central database of records and as we build up clients in different 
regions we'll sync the regions to the central database. If the customer 
dosen't exist, we'll copy them in, and if they already are on file, we'll 
update the information if there's changes.

Right now I've been using queries and SQL as I don't know VBA, but despite 
my efforts, the product I've made never produces tables with the final result 
as the original.

hi,

On 18.12.2009 17:51, CJC Digital wrote:
> Right now I've been using queries and SQL as I don't know VBA, but despite
> my efforts, the product I've made never produces tables with the final result
> as the original.
And your concrete problem is what?

Despite the fact that you have not entirely copied or mimicked the old 
programs logic...

You must be more specific. Concise and complete examples will help a lot.

mfG
--> stefan <--