calling groups of records

[tjrobert82]

I have a very large data table with groups of data points all assigned to a "Test ID". Suppose there are 1000 records from ten tests. There are four columns: "Field 1", "Field 2", "Primary ID" and "Test ID". Fields 1 and 2 have my data information which I want to run calculations on. Test ID would have values from 1 to 10 and would describe which test the data in Field 1 and 2 represents. I want to write a function that returns calculations from just one test (whichever test is being shown in a form). The reason I can't just make a select query is that the calculations need to be performed on the first 20 data points (out of 100) from each test. How can I call up and reference this data in a function module?

For the sake of argument, assume that all of the information is in a table named "DataTable" and that the form with the current Test ID record is "MasterForm".

I think it's just a syntax thing I don't get, because I can do it easily in Excel. How do you get the module to "look" at the right data? Thanks for the help!

 

[WayneRyan]

TJ,

Select Top 20 ...

Wayne