Updating a feild in a table from a Query

[Tuckerbox2081]

I have a number hat has been caluated in a qury which I want to be kept in a feild in a table. I need help to work this out and Kept it K.i.s.s

[JoeM]

Why do you need to store it in a table if it can be calculated in a query?
It actually usually goes against the rules of Database Normalization to store anything that can be calculated at the table level.
If it can be calculated in a query, there is usually no reason to store it at the table level (unless you are creating some sort of historical archive).

[Tuckerbox2081]

I have a auto number set up that I want to show on a form. This will be a ref number for the info inputted the ref number looks lick this S44/14/001.I would like to recoed this with the info in the table.

[June7]

How are you calculating this in a query? You are simply concatenating 3 fields? Again, no reason to save this calculated value. But if you must save, run an UPDATE query

[JoeM]

Note that Forms can have Queries as their control source as well as Tables.
Actually, pretty much anything that you use Tables for (Forms, Report, exports), you can use Queries for.
Which is why it usually isn't necessary to store anything in a Table that can be calculated in a Query.
There are instances in which you might need to store a calculation in a Table, but those are usually pretty rare.