Query Criteria Between 2 Text Values - Access 07

[Jeff Garrison]

All -

I have a query that looks at the text values of two different combo boxes
(ManagerByStart, ManagedByEnd), which are Text. When the user clicks a
'Refresh' button, a select query returns the records based on the from an to
criteria that is selected on the form via combo boxes. The criteria for the
Project Manager (prjProjectManager) is as follows:

=[Forms]![frmProjectListingIC]![ManagedByStart] And
<=[Forms]![frmProjectListingIC]![ManagedByEnd]

If I leave the criteria as is, it won't return any records. If I take out
the And and the second part of the criteria, it works and vice versa. The
process worked fine in 2003.

Has something changed in 2007 where this won't work or do I need some kind
of modification to the criteria? I've tried using Between, but that wont'
work either.

Any help would be appriciated.

Thanks.

Jeff

 

[scubadiver]

What is the purpose of '><=' or is that a typo ??

All -

I have a query that looks at the text values of two different combo boxes
(ManagerByStart, ManagedByEnd), which are Text. When the user clicks a
'Refresh' button, a select query returns the records based on the from an to
criteria that is selected on the form via combo boxes. The criteria for the
Project Manager (prjProjectManager) is as follows:

=[Forms]![frmProjectListingIC]![ManagedByStart] And
<=[Forms]![frmProjectListingIC]![ManagedByEnd]

If I leave the criteria as is, it won't return any records. If I take out
the And and the second part of the criteria, it works and vice versa. The
process worked fine in 2003.

Has something changed in 2007 where this won't work or do I need some kind
of modification to the criteria? I've tried using Between, but that wont'
work either.

Any help would be appriciated.

Thanks.

Jeff