Search results

I have a recordset based on a union of two queries. From this dataset I want to select a random set of records. I am assuming its better to do this in VBA rather than the query grid? Also is it possible to creat a field in the recordset that is not bound to a table, I guess I will need an...

I have a query that returns x number of rows. From that data I need to select for example 10% of those rows from the original sample but a random selection. I dont have a clue where to start with that in the query grid. advice would be much appreciated. sql that forms original sample; SELECT...