i tried as below and it worked fine.
![]()
strsql = "SELECT DISTINCT printpoolno FROM tblmaster where username='" & Application.UserName & "' AND Date1=#" & Format(DateValue("04/03/2015"), "mm/dd/yyyy") & "#" MsgBox strsql
i tried as below and it worked fine.
![]()
strsql = "SELECT DISTINCT printpoolno FROM tblmaster where username='" & Application.UserName & "' AND Date1=#" & Format(DateValue("04/03/2015"), "mm/dd/yyyy") & "#" MsgBox strsql
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks