Your last UPDATE statement should work. Access is often a bit crap though so although it should work, it probably won't. Thanks Microsoft Access dev team (probably more specifically the updates to JET).
Unfortunately, the only way I can recommend is to create a temp table based on a query which does a GROUP BY on the Date column you are attempting to ...
You need UPDATE, not INSERT:
SET F = f / (SELECT SUM(f) AS fSum FROM MyTable) ;
MyTable AS my,
(SELECT SUM(f) AS fSum FROM MyTable) AS total
SET my.F = my.f / total.fSum ;
As mendosi commented, having two columns with same name in different (upper/lower) case, like f and F is not recommended in any DBMS and (not sure) ...
Open the query designer for a new query.
Add the tables you are interested in.
Drag the field number from table1 to table2
Drag the field code from table1 to table2
Right click on each of the lines between the two tables and select join properties
Select option 2
Lastly in the bottom section of the designer select the columns you wish to see in your ...
The query would look something like this:
LEFT OUTER JOIN [Table2]
ON [Table1].[Code] = [Table2].[Code]
AND [Table1].[Number] = [Table2].[Number]
Being that this is Access, you'll have to check the documentation for the IIF statement,...
For every row where Place1 is null, you are returning an empty string as item_sku. So without DISTINCT all such entries would be returned as
and DISTINCT condenses them to just one row. Do you need that row in the output? To me, it does ...