Member Avatar

Hi All,

How i can restrict the numbers of customer from database?
I use adodb with access.
I know how to retrieve customers from database but i don't know how to restrict it to spesific numbers.

Best Regards.
Sturdy

  • 2 Contributors
  • forum 4 Replies
  • 189 Views
  • 1 Hour Discussion Span
  • comment Latest Post Latest Post by Sturdy

Recommended Answers

Answered by Jx_Man 987 in a post from

To limit your retrieved data from database you use TOP clause in your sql statement.
You can read in this site.

Select TOP 50 * from Customers
Jump to Post

All 4 Replies

Member Avatar

Can you show your sql query to retrieve customers from database?

Member Avatar

Yes, this my query to retrieve data :

Dim rs As New ADODB.Recordset
rs.Open "SELECT * from Customers", Conn,adOpenStatic ,adLockOptimistic

However, i want to restrict all data to recordset is just only 50 customers.
How i can do this? Please help.

Member Avatar

To limit your retrieved data from database you use TOP clause in your sql statement.
You can read in this site.

Select TOP 50 * from Customers
commented: Worked Perfectly +1
Member Avatar

Wow...That code worked perfectly.
Thank you sir.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!