Recent content by smasak

  1. S

    Select top x values in query

    I think it's not so easy.. Look, in Qry QRTOTAL there are fields SCORE1, SCORE2, SCORE3 by category and Nation and Date RACE. In Qry QRTOTALTEAM they are summed up according to the nation and Date RACE. But did not summed up the only 3 best scores but all nation scores. For example in Qry...
  2. S

    Select top x values in query

    Thank you for your answer, but it's not what I want. I don't want the first five results but the 5 bigger ones.
  3. S

    Select top x values in query

    Good evening, in this sample i have a query named "QRTOTALTEAMcateg" which showing the total results by category, country and race. I would like to select the top 4 results for PC category and the top 3 for SPR category.I tried with the command "select top 3" but my knowledge is poor . The...
  4. S

    Hello from Greece

    Good afternoon, my name is Sakis, i am 45 years old and i am an accountant who finds many solutions with access.I consider your site very interesting and has given me many solutions from the posts here. I am new to Microsoft Access. I do not have so much knowledge in VBA and my English is not...
Back
Top Bottom