Member Avatar for Masterace

Need to sort my database such that to view a single customers payment over a year

  • 3 Contributors
  • 3 Replies
  • 96 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by logonchristy
Member Avatar for debasisdas

You need to add ORDER BY clause to your SQL.

Select the field on which you need to sort (may be payment _date in your case)

commented: nice.. +1
Member Avatar for Masterace

You need to add ORDER BY clause to your SQL.

Select the field on which you need to sort (may be payment _date in your case)

does the same apply if am using Access

Member Avatar for logonchristy

what you mean single costomer over a year...

Be a part of the DaniWeb community

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