I can do this in SQL Server:
SELECT 'HERRAMIENTA ELÉCTRICA' AS TIPO_PRODUCTO, 0 AS DEPRECIACION, (select sum(empid) from HR.employees) STOCK
But in Access the same query returns the following error:
Query input must contain at least one table or query
So what would be the best option to emulate this? Make a query to a table X that has at least one record and in case of having more limit it sounds dirty to me, following what indicates the error of missing at least one table in the query, so I look for a better way to do it.
PDTA: Question based on a question I have also done in SO in English.