Query make me crazy (1 Viewer)

[n3wguys]

Good Day for you, Sir

Have you ever experienced the strangeness of that query with "multiple criteria" in the ms access 2013 or 2010 can not show the result as well(blank datasheet)?

please help me.:banghead:

noticed: The first :Result of query previously, could be run and show the result in datasheet as well.

 

[plog]

Yes, usually its the users fault for applying criteria that is mutually exclusive:

WHERE ([LastName] Like "J*") AND ([LastName] Like "S*")


Often times its not that obvious, but still impossible to achieve. Can you post your SQL?

 

[n3wguys]

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;


These is code previously could be show the result...without change,without modified.
as we know, this code have run and show the result what I want.. after Im installing vb6 for re develop my old program, this query does not show the result.
I m not sure, this affect or conflict or what... sorry if I m wrong..

 

[plog]

Date comparisons are always tricky. You probably need to delimit the data from the form with '#'

Here's a microsoft article that details how to use dates: http://support.microsoft.com/kb/210276

 

[n3wguys]

write "#" ?
where I will write ?.
I make code in SQL design in ms access, so I think I needn't "#",
Except there I will write direct the date value..
as like #01/01/2014# and #01/01/2015#. and we know, there code or each of value will be submit from txtstartDate and txtendDate(be half of Form).

sorry if I m wrong.. need suggestion.

 

[n3wguys]

[Solved]Query make me crazy

Dear All,

What I do in facing the problem, finally is solved. I just remove written "format"
in SQL format (Format([Time1],"dd/mm/yyyy"))

to

WHERE ((([Time1]) >=[forms].[printDataLogin].[txtstartDate] And ([Time1])<=[forms].[printdatalogin].[txtenddate]))

thanks for coming and reading this thread.