database query

W

Workinghard

Currently,
I have a table with fields as follows:

ITEM | STATE | AMOUNT |

I use a query statement such as:
-resultspage.asp?state=Nevada-

And I get results that include all ITEMS from STATE of Nevada.

My quesion is what would I add to this Statement to get in order to get the
results that
include all ITEMS from STATE AND AMOUNT less than $1000
 
S

Stefan B Rusynko

resultspage.asp?state=Nevada&amount<1000




| Currently,
| I have a table with fields as follows:
|
| ITEM | STATE | AMOUNT |
|
| I use a query statement such as:
| -resultspage.asp?state=Nevada-
|
| And I get results that include all ITEMS from STATE of Nevada.
|
| My quesion is what would I add to this Statement to get in order to get the
| results that
| include all ITEMS from STATE AND AMOUNT less than $1000
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database query 1
Using Access Database to build contracts with fields on pdf document 0
Page numbering with Merged Document and IF statements 1
Creating a Chart on form from selected data in query. 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using Index, Match and Search to populate items to a calendar view 2
Excel does not accept text format! 0
List all tables, including document structure 0

Top