emaduddeen
Well-known member
- Joined
- May 5, 2010
- Messages
- 171
- Location
- Lowell, MA & Occasionally Indonesia
- Programming Experience
- Beginner
How do I test an amount entered into a textbox is <= the largest number in a table?
Hi Everyone,
Can you tell me how to fix my query so I can determine if an amount entered into a textbox is < the largest number in a database table?
Here is some sample data:
If the user enters 35 I'm looking for the query to indicate that this number 35 is < the largest number which happens to be 50.
Here is the query I tried to use:
I get this error when running it so I know my query is wrong:
Can you show me how to do this query so it will work?
Thanks.
Truly,
Emad
Hi Everyone,
Can you tell me how to fix my query so I can determine if an amount entered into a textbox is < the largest number in a database table?
Here is some sample data:
VB.NET:
CategoryNumber
----------------
10
20
30
40
50
If the user enters 35 I'm looking for the query to indicate that this number 35 is < the largest number which happens to be 50.
Here is the query I tried to use:
VB.NET:
strSqlStatement =
"Select 1 " & _
"From Categories " & _
"Where @CategoryNumber < Max(CategoryNumber) "
I get this error when running it so I know my query is wrong:
VB.NET:
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
Can you show me how to do this query so it will work?
Thanks.
Truly,
Emad