<div>
gpotenza said:<br />
&gt;&gt;datatype of Text <br />
<br />
If the data type is text, then why are you using a data type of datetime for the filter comparison?<br />
<br />
Compare text with text and datetime with datetime; when you try to mix them up you can get<br />
unexpected results.
</div>


<div>
The data in the field represents a time that I need to filter by a timespan. (for example from 15:00 to 20:00) &nbsp;How would I do that if the field datatype is text?
</div>


<div>
If the text is stored as hh:mm, then try:<br />
<br />
[TimeField] Between &quot;15:00&quot; And &quot;20:00&quot;<br />
<br />
or if that does not work:<br />
<br />
[TimeField] &gt;= &quot;15:00&quot; And [TimeField] &lt;= &quot;20:00&quot;<br />
<br />
Why are you storing this as text and not as datetime?
</div>


<div>
<div class="content wysiwyg-content">
I have a fieldin a table with a datatype of Text that I can use the Format([CollectTime],&quot;hh:n<wbr />n:ss&quot;) function to successfully text to time. &nbsp;However I need to filter this data in the same query.<br />
<br />
For example &gt;=#15:15:00#<br />
<br />
When I do I do not get results even though I can see some would qualify.<br />
<br />
Help this is urgent!
</div>
</div>


I have a fieldin a table with a datatype of Text that I can use the Format([CollectTime],"hh:nn:ss") function to successfully text to time.  However I need to filter this data in the same query.

For example >=#15:15:00#

When I do I do not get results even though I can see some would qualify.

Help this is urgent!

gpotenza said:
&gt;&gt;datatype of Text 

If the data type is text, then why are you using a data type of datetime for the filter comparison?

Compare text with text and datetime with datetime; when you try to mix them up you can get
unexpected results.

The data in the field represents a time that I need to filter by a timespan. (for example from 15:00 to 20:00)  How would I do that if the field datatype is text?

If the text is stored as hh:mm, then try:

[TimeField] Between &quot;15:00&quot; And &quot;20:00&quot;

or if that does not work:

[TimeField] &gt;= &quot;15:00&quot; And [TimeField] &lt;= &quot;20:00&quot;

Why are you storing this as text and not as datetime?

Convert Text to Time and Filter

I have a fieldin a table with a datatype of Text that I can use the Format([CollectTime],&quot;hh:nn:ss&quot;) function to successfully text to time.  However I need to filter this data in the same query.

For example &gt;=#15:15:00#

When I do I do not get results even though I can see some would qualify.

Help this is urgent!

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.