pcsoft.us.windevCopyright 2026, PC SOFT9 Oct 2019 09:33:36 Z9 Oct 2019 09:33:36 ZHi to all. I'm a very beginner in Windev and an OLD VB programmer. I have a query as follows SELECT Int(Year(BilSorge.Data)) AS [Yr], Int(Month(BilSorge.Data)) AS [Mnth], LEFT(BilSorge.Sottoconto,2) AS Master, MID(BilSorge.Sottoconto,3,3) AS HeadAccount, RIGHT(BilSorge.Sottoconto,5) AS Account, BilSorge.Descrizione AS Description, BilSorge.Dare AS Debit, BilSorge.Avere AS Credit, BilSorge.Dare - BilSorge.Avere AS Balance FROM BilSorge The connection is to an ACCESS database via OLEDB connection The int function has to be passed as is. If I run the test on the query it works fine because I set "run with hQueryWithoutCorrection in test mode." The problem is that in the PVT_Control it returns an error because the system is changing the int() into Integer() I read somewhere that you need to set that option in the Query description Advanced option but I don't see advanced option in the query description form. Any Help? Thank you30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67318-pivot-control-and-query-from-oledb-access/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)