access query time "expression is typed incorrectly, or it is too complex..."

Hi -

I am currently exporting a data table out of a foxpro database which I have no access to modify. I export the data files into an excel spreadsheet, then copy and paste the data into a form in Access 2010. In the original data, there is a field "TIME" that is being recorded as text, not date/time.
I base many of my reports in this database off a query that takes this text format "time" field, and converts it do date/time using CDate(time). I have used this new field "TimeConverted" for max and min calculations within a query without problem.

Now I am trying to use a query to filter between two times and I'm getting the error "this expression is typed incorrectly, or it is too complex to be evaluated..."

In the query I am trying to use, I am already using three criteria fields without issue. I have also tried building a query to filter the time that is based on my original working query which has the three criteria. neither will work when I try to use any criteria in the TimeConverted field, whether I have a Time criteria from a form (which is what I want) or I manually put in a time filter, i.e. <#7:30:00 AM#

i have tried to put in a filter in the Time field (which I know is text format) and the query will run, but with no results, even though I know data exists within the parameters I've given it.

How do I get this query to work where I can ultimately use criteria "between [TimeStartFromFormField] and [TimeEndFromFormField] in either the Time field (text format) or CDate(Time field with is text formatted)?

Help is greatly appreciated.