preprocessing raw access data

[Timme1]

Hello,

I have a access database with uncomplete data. I need to do some work first with the table.
e.g. I need to apply expressions on the data, like giving a certain value IF ..., change values of fields with inconsistent data, new fields with sum of two other field etc... I want to change the tables, not a certain data view in a query.

I could do this in excel, but is it also possible in my access tables itself? My IF operator and sums etc... are concerned with different tables, so it doesn't seem possible in excel.

I hope someone can help me

 

[DavidOlly]

It sounds as if an "Update Query" could satisfy your needs