trouble querying in text column

[AT76]

Hi,

I'm pulling tables down from an Oracle database into an access database. I need to do the following filteron onw of the fields: "between ### and ###" (I need to filter for a specific number range.) The problem is that this field is of type text therefore the filter is not working. Is there a way make this happen? How can I convert the field that I need from text to a number field?

I have also tried the following, I made the query into a make table query and ran the query without the filter. Afterwards I have tried converting the text field into a number field but Access is not letting me.

Thanks for any advice. I appreaciate any help provided with this.

 

[dhookom]

What happens if you wrap the field you want to filter on in Val([Your Field])?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[AT76]

dhookom, don't know what you mean. Could you give me an example.

Thank you so much!

 

[dhookom]

You haven't provided any SQL view or table or field names or other information that I would think is significant. Consider using:

SELECT...
FROM...
WHERE Val([...]) Between ### and ###

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[AT76]

Thanks dhookom!