User input of numbers

[John V]

The criteria that I am trying to determine is to have a user input a number
and then the query show all the records that have a value of greater than the
number inputted by the user.
This is the criteria I was trying to get to work:

[Enter Weight To Be Greater Than]

if the user inputs "15" in the msg box, no records are displayed.
However, when I change the criteria to:

15

records are displayed.
Any thoughts?

Thanks in advance
John

 

[George]

Dear John,
I have used it in Access 2003 and there is no problem when inputing 15 (and
not "15")

Ο χÏήστης "John V" έγγÏαψε:

The criteria that I am trying to determine is to have a user input a number
and then the query show all the records that have a value of greater than the
number inputted by the user.
This is the criteria I was trying to get to work:

[Enter Weight To Be Greater Than]

if the user inputs "15" in the msg box, no records are displayed.
However, when I change the criteria to:

15

records are displayed.
Any thoughts?

Thanks in advance
John

 

[George]

I assume that the field is a Number field, right?

Ο χÏήστης "George" έγγÏαψε:

Dear John,
I have used it in Access 2003 and there is no problem when inputing 15 (and
not "15")

Ο χÏήστης "John V" έγγÏαψε:

The criteria that I am trying to determine is to have a user input a number
and then the query show all the records that have a value of greater than the
number inputted by the user.
This is the criteria I was trying to get to work:

[Enter Weight To Be Greater Than]

if the user inputs "15" in the msg box, no records are displayed.
However, when I change the criteria to:

15

records are displayed.
Any thoughts?

Thanks in advance
John

 

[John V]

It is a calculated field.
The field is...
Total Weight: [PartWeight]*[qty]+[BoxWeight]

 

[John V]

Sorry......
the query field property format is general number

 

[KARL DEWEY]

Try this --

Val([Enter Weight To Be Greater Than])

 

[John V]

I figured it out.....
It was simple once I got it.
By using... >[weight to be greater than] it was returning records of 2
greater with 15 beign entered.
By simply using.... >1*[weight to be greater than] it returned the
results I was looking for.

John

 

[John V]

That works perfect also!

Thanks Karl