ado record set
-
i was new 2 recordset to access same table
when i run the porgram then so quick to stop
but i deleted the rs1 that progam can run
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.path & "\eventf.mdb"rs.Open "Select * from event", dbrs1.Open "Select * from event", dbthanks
-
hi jason,
dnt mean to be rude or anythin but if u can explain what you want done or what the problem is that'b great coz i cant understand what want done
Elabuwa
-
i want to access same table first record, but one is asc and the other is desc
-
From what I can understand I assume that you want the first record when you select them ascending as well as descending.
Just use the IF clause and ORDER the SELECTION process.
For Example,
If you want ascending just type,
rs1.open "SELECT name FROM customer_details ORDER BY name",cn1
this will give you the whole table in the ascendin.
If you want descending just type,
rs1.open "SELECT name FROM customer_details ORDER BY name DESC",cn1
Hope this helps.
Elabuwa
-
hi i think you want to get the highest and lowest values u can ues max and min functions instead. e.g. select max( from
Enter your message below
Sign in or Join us (it's free).