Hello,

I got a directory with a number of databases files in it. Every file has one
table and the dimensions of all different tables (files) are different.
What I want to do is add 2% to every field of every record in every table, I
only managed to get some fields out of it, and caus I'm no DB expert, I
thought, maybe someone of u can help me.

Thanx

Niels

This SQL query would do something like that:

UPDATE Table1 SET Table1.Field1 = [Field1]*1.02, Table1.Field2 =
[Field2]*1.02;

In Access it is called an 'Update Query'

If you don't know the number of fields, you may have to write some vb code
to find out.