K
KHogwood-Thompson
I have a query that produces a list of nominal codes and YTD values for a
period based on a parameter in a form.
I would like the total of the YTD values to be used in an update query to
change the value of a nominal code in a table.
The query that produces the list has the following SQL:
SELECT DISTINCTROW [P&L ALL].[NOMINAL REF], [P&L ALL].PERIOD, [P&L ALL].YTD
FROM [P&L ALL];
I would like an update to query to take the total of the YTD column above
and update the YTD field on a table called [NOMINAL YTD SUMMARY TABLE] for
one nominal code called "4800", the field name in the table being "NOM REF"
K Hogwood-Thompson
period based on a parameter in a form.
I would like the total of the YTD values to be used in an update query to
change the value of a nominal code in a table.
The query that produces the list has the following SQL:
SELECT DISTINCTROW [P&L ALL].[NOMINAL REF], [P&L ALL].PERIOD, [P&L ALL].YTD
FROM [P&L ALL];
I would like an update to query to take the total of the YTD column above
and update the YTD field on a table called [NOMINAL YTD SUMMARY TABLE] for
one nominal code called "4800", the field name in the table being "NOM REF"
K Hogwood-Thompson