URGENT - DataEnvironment - SQL Query

[HanneSThEGreaT]

Subject Urgent - DataReport / DataEnvironment
Category Database
Posted by HanneSThEGreaT on 9/25/01 at 07:36 pm
Rating not rated


Hello.
I created a Data Environment, included the fields I want to print on the Data Report. I used an SQL statement to retreive the fields to print, as one would normally do. My question is: how can I modify that SQL statement to print (Example)all the payments which is less than $100, instead of All the payments?
If this question is unclear please let me know
Please help this is very urgent
Thanx




F. T. W.

[d.paulson]

Use the where clause

strSQL = "SELECT * FROM YourTable WHERE YourField < 100"

David Paulson

[HanneSThEGreaT]

Hello Paul, thanx for the help. I've got a few question though.
1) Where do I have to put this in? In the DataEnvironment itself?
2)
What if I want the user to select the amount they want to print(Example) less than 200, or = 200?

Thanx

F. T. W.