4

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 ...


4

You need UPDATE, not INSERT: UPDATE MyTable SET F = f / (SELECT SUM(f) AS fSum FROM MyTable) ; or: UPDATE 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) ...


2

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 ...


1

The query would look something like this: SELECT [Table1].[Code], [Table1].[Number], [Table2].[Name1], [Table2].[Family] ... FROM [Table1] 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,...


1

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 item_sku Place1 -------- ------ NULL NULL NULL NULL NULL … … and DISTINCT condenses them to just one row. Do you need that row in the output? To me, it does ...


Only top voted, non community-wiki answers of a minimum length are eligible