Calculating a percentage on data results in MS Access 2003

• Brownie-744080

  Grasshopper

  Points: 20

  More actions

  May 13, 2008 at 3:35 am

  #185403

  I have created a query to pull off some results in MS Access 2003 however from this I would like to randomly display only 10% of the results can such a query be written?

  Thanks

  Paulette

• Perry Harts

  Ten Centuries

  Points: 1271

  More actions

  May 13, 2008 at 2:02 pm

  #814777

  You can create a view or a store procedure to select top 10%. If you are connected via an ODBC you can link the view to Access.

• Brownie-744080

  Grasshopper

  Points: 20

  More actions

  May 14, 2008 at 4:30 am

  #815024

  Hi Perry,

  Thank you for responding I will give this a try and let you know how I get on Once again thank you.

  Paulette