User Profile

Collapse

Profile Sidebar

Collapse
Emzo
Emzo
Last Activity: Jun 23 '07, 07:35 AM
Joined: Jun 15 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Emzo
    replied to Top function in Access
    in Access
    the problem solved ..
    good day to all of you!!!
    See more | Go to post

      Leave a comment:

    • Emzo
      started a topic Top function in Access
      in Access

      Top function in Access

      hi everyone !!
      i have a table (take a look of atached image) and i wont to get from that table top 3 records witch have the top 3 maximal value of NumberOfTickets ...
      but than i write :

      SELECT top 3 NumberOfTickets
      FROM GetSumOfAllTick etsForDate;

      it gives me 3 first records from table ,unregarding the quantity of values in NumberOfTickets column.
      what i am doing wrong?
      thanks !!!!!...
      See more | Go to post
      No activity results to display
      Show More
      Working...