Select Query Problem

Originally posted by : Hussain ali (inboxdollarspk@yahoo.com)Please help me to solve this problem i want to select Username from Orderstable table Name = Orders with fields = order,Country,Name i want to Select Those peoplse who From Usa And Order Amount is equal to 500i am store Country Name in variable called "Con" and oder amount Save in variablecalled "amo"Please help me to create a Query Please Help Me Thanks Thanks Thanks Thanks Thanks Thanks

Originally posted by : TheDude (TheDude@bananateam.nl)try something like this:SELECT * FROM Orders WHERE Country = " & con & " AND Amount = " & amo regards The DudeSoftware EngineerInfopart Automatisering B.V.www.infopart.nl------------Hussain ali at 12/24/2001 5:05:40 PMPlease help me to solve this problem i want to select Username from Orderstable table Name = Orders with fields = order,Country,Name i want to Select Those peoplse who From Usa And Order Amount is equal to 500i am store Country Name in variable called "Con" and oder amount Save in variablecalled "amo"Please help me to create a Query Please Help Me Thanks Thanks Thanks Thanks Thanks Thanks

Originally posted by : Manish (manish87@hotmail.com)try thisrs.open "select * from orders where country='" & 'USA' & "'and Amount='" & '500' & "'",connectionif not rs.eof thendo while not rs.eofname=rs("name")rs.movenextloopelsename="None"end ifyou will get the usernames in the variable "Name"okieManish------------TheDude at 1/7/2002 1:20:12 PMtry something like this:SELECT * FROM Orders WHERE Country = " & con & " AND Amount = " & amo regards The DudeSoftware EngineerInfopart Automatisering B.V.www.infopart.nl------------Hussain ali at 12/24/2001 5:05:40 PMPlease help me to solve this problem i want to select Username from Orderstable table Name = Orders with fields = order,Country,Name i want to Select Those peoplse who From Usa And Order Amount is equal to 500i am store Country Name in variable called "Con" and oder amount Save in variablecalled "amo"Please help me to create a Query Please Help Me Thanks Thanks Thanks Thanks Thanks Thanks