OK Here we go. I modified the statement as follows. Now I got the two screens asking for the initial and ending date, but I got the "Function argument value,type or count is invalid" message...

SELECT Ventas.fechaonly, Ventas.totalvta, Ventasdsg.codigonues,;
Ventasdsg.descripcio;
FROM scaledata!ventas INNER JOIN scaledata!ventasdsg ;
ON Ventas.cvevta = Ventasdsg.novta;
WHERE Ventas.fechaonly BETWEEN CTOD(?date1) AND CTOD(?date2)

Following up with this question: what other methods, besides a view are there to get the same results?

Thanks in advance

Ulises