Dear my friend
SELECT ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1
FROM ActivityLogs
WHERE (((Format([Time1],"dd/mm/yyyy"))>=[forms].[printDataLogin].[txtstartDate] And (Format([Time1],"dd/mm/yyyy"))<=[forms].[printdatalogin].[txtenddate]))
GROUP BY ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1
ORDER BY ActivityLogs.Time1;
----------------------------------------------------------------------------------
Cut of code above : previously is okay and show me the result, but right now, I can't see the result when the query is run.
what the problem come from access ?
please help me.
noticed: I have two office ( 2010 & 2013) have been installed. Before it, I just run access 2013 to work always. after three days later, I run my program(ADP) that have been created with office 2010.
SELECT ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1
FROM ActivityLogs
WHERE (((Format([Time1],"dd/mm/yyyy"))>=[forms].[printDataLogin].[txtstartDate] And (Format([Time1],"dd/mm/yyyy"))<=[forms].[printdatalogin].[txtenddate]))
GROUP BY ActivityLogs.NameForm, ActivityLogs.NameUser, ActivityLogs.Time1
ORDER BY ActivityLogs.Time1;
----------------------------------------------------------------------------------
Cut of code above : previously is okay and show me the result, but right now, I can't see the result when the query is run.
what the problem come from access ?
please help me.
noticed: I have two office ( 2010 & 2013) have been installed. Before it, I just run access 2013 to work always. after three days later, I run my program(ADP) that have been created with office 2010.
