Hi, I'm pretty new to ms access. I made an access database with 2 tables in it. the primary key of the first is linked with a field of the second table. the second table contains valuta. Then I made a query that makes the sum of these valuta, based on the field that is linked with the first table. my question is, is it possible to insert the result of the query back in the first table in a specific field? I hope someone understands what I'm trying to say :) this might help: (sorry for the dutch in it) any idea's? if this is not possible or difficult, can I autoinsert the value in a form instead of a field in the table? any help apreciated! Johan

it seems pretty easy if i understand what you're talking about... "if this is not possible or difficult, can I autoinsert the value in a form instead of a field in the table?" that would be as easy as adding a "hidden" input field in the form (type=hidden). however i dont know anything about that access stuff that you're using so i cant help with what you'd preferably like. FBI_Agent

If I understand what you're saying, you are talking html. I don't think I can use that in access... I've been thinking about it, and I was wondering if there is an UPDATE query as in MYSQL. But I know too little of access to find out what I should be looking for. It's probably easier to use the forms in access.

Nevermind, I was able to do it using forms. although it isn't inserted into a table in this way.

OK, I am having a similar problem. I have a field that needs the age computed, so I created a query to do this. Now, how do I link the query results back into that tables field?

I thought about these things, and I don't think it's possible unless you use scripts. it's because the query uses data from that table but it isn't possible to add data to that table. I think it should be possible to write a script that reads the result of the query and then adds data to the table, but I don't know anything about vb-scripts, so I don't know how to make such a script. Johan