Access Query

<i><b>Originally posted by : Maged Wahba (magedw@sbmt.com)</b></i><br />Hi,<br /><br />I need to know couple pf things<br /><br />1-I create a query in an Access Database, How can I use this Query from my ASP code?<br /><br />2-How can I pass parameter to the query?<br /> (I need to change the Order By clause)<br /><br />Thanks

<i><b>Originally posted by : Dal (dal@lanaddicts.com)</b></i><br /><br /><br /><br />------------<br />Maged Wahba at 2/16/2000 10:31:26 AM<br /><br />Hi,<br /><br />I need to know couple pf things<br /><br />1-I create a query in an Access Database, How can I use this Query from my ASP code?<br /><br />I guess you use the query-builder (SQL-builder) in Access?<br />After you have built the query, just go to the Show-menu, and choose Show SQL. Then you can just copy and paste the code into you asp-script.<br /><br /><br />2-How can I pass parameter to the query?<br /> (I need to change the Order By clause)<br /><br />If you use the SQL-builder, you can see there is a field called "criteria". Just put DESC or ASC into it, and thats is. You can put all sorts of info into that field, of course. For example, if you have a namedatabase, and you want to find people that is named "Maged", just put Maged into the criteria field.<br /><br />Hope this helps