Returning more values than I want in MS Access 2003

[Emmi]

I have a very simple query that I am trying to pull any data back between the number 1 and 3 in a field.

What is happening is I am also getting 12 and 11. I only want the number 1. How do I specify to return only the number 1 not the 11 or 12?

Here is my code:

SELECT entity.name, line.renewal
FROM entity INNER JOIN line ON entity.entityid = line.entity
WHERE (((line.renewal) Between [What month do you want to begin with?] And [What month do you want to end with?]));

Thanks in advance for any help.

Emmi

[FishVal]

I have a very simple query that I am trying to pull any data back between the number 1 and 3 in a field.

What is happening is I am also getting 12 and 11. I only want the number 1. How do I specify to return only the number 1 not the 11 or 12?

Here is my code:

SELECT entity.name, line.renewal
FROM entity INNER JOIN line ON entity.entityid = line.entity
WHERE (((line.renewal) Between [What month do you want to begin with?] And [What month do you want to end with?]));

Thanks in advance for any help.

Emmi

Hi!

Its very likely that field line.renewal is Text type.
You should change it to Number type or use Val(line.renewal) in query.

Good luck.

[Emmi]

Thank you so much!!! That was exactly what the problem was. You are the best!

[FishVal]

Thank you so much!!! That was exactly what the problem was. You are the best!

Very glad that could help you. :)