Hi
My database is linked to SQL server using linked tables.
I am trying to move some of my queries to being passthrough queries for efficiency and speed. I am trying to do this primarily for combo boxes, and for reports.
Can passthrough queries deal with the access date() function ?
eg:
SELECT *
FROM Tbltest
WHERE (((Tbltest .dateMade)>="1/" & Month(Date()) & "/" & Year(Date()) And (Tbltest .dateMade)<=Date()))
Or do passthrough queries get converted to SQL automatically ? ie. getdate()
Thank you
My database is linked to SQL server using linked tables.
I am trying to move some of my queries to being passthrough queries for efficiency and speed. I am trying to do this primarily for combo boxes, and for reports.
Can passthrough queries deal with the access date() function ?
eg:
SELECT *
FROM Tbltest
WHERE (((Tbltest .dateMade)>="1/" & Month(Date()) & "/" & Year(Date()) And (Tbltest .dateMade)<=Date()))
Or do passthrough queries get converted to SQL automatically ? ie. getdate()
Thank you
Last edited: