counting dates and inserting them to table field

[accessgr]

i have to tables . relation one to many. i want to count the number of dates
of the field of one table --- and insert the result to the filed of the other .
AND USE IIT TO A FORM
i managed to create the query


SELECT COMPANY.COMPANY, COMPANY.SOCIALNUMBER, Count(DATESTIRKE.[STRIKEDAY]) AS [CountOfSTRIKEDAY]
FROM COMPANY LEFT JOIN DATESTIRKE ON COMPANY.SOCIALNUMBER = DATESTIRKE.SNUMBER
GROUP BY COMPANY.COMPANY, COMPANY.SOCIALNUMBER;


AND THE QUERY IS WORKING



BUT...
WHEN USING IT TO A FORM IT DOESNT DISPLAY CORRECT RESULTS CAUSE ITS NOT INSERTING THE RESULTS TO THE FIELD OF THE TABLE I WANT AND IT THEREFORE DOESNT SAVE - UPADTE ETCH

[orange]

Don't store a calculated field in your table.
Use a query to do the calculation whenever you need it.
Use the query as the source for the Form.

To help us understand your environment please post a picture of your tables and relationships.

[orange]

Now that you have a query that works, why not use the Form wizard and let Access build you a Form. You can always adjust it to customize it.

[accessgr]

you have chosen fields of which access wizard could not....
maybe you have chosen fields of a table and of a query based on the same table....

[orange]

Can you post a copy of your mdb with the query and some data? But no need for all the data or any confidential info.