Pulling arrays of data, that match a certain criteria, from a query.

[rowardHoark]

My query "ArrheniusPlot" looks like

Report_number...Temperature...Time
1.....................130...............600
1.....................120...............2000
1.....................110...............3200
1.....................100...............4600
2.....................150...............1100
2.....................140...............1600

My Function "temperaturePrediction" uses Report_number as an input.

For a given Report_number, I want to be able to get:

sum(Temperature*ln(Time))
sum(ln(Time))
sum(Time)
sum((ln(Time)^2))

How could I achieve this? Use an array, DLookUp?

 

[rodmc]

My query "ArrheniusPlot" looks like

Report_number...Temperature...Time
1.....................130...............600
1.....................120...............2000
1.....................110...............3200
1.....................100...............4600
2.....................150...............1100
2.....................140...............1600

My Function "temperaturePrediction" uses Report_number as an input.

For a given Report_number, I want to be able to get:

sum(Temperature*ln(Time))
sum(ln(Time))
sum(Time)
sum((ln(Time)^2))

How could I achieve this? Use an array, DLookUp?

Do you need to use DLookup at all? Cant you just use expressions within a query for your calculations (maybe Im just picking you up wrong here)

 

[rowardHoark]

Thank you rodmc, using a query is an elegant solution. Had some trouble summing all the data for a particular report, but this link helped http://www.access-programmers.co.uk/forums/showthread.php?t=204103.

 

[rodmc]

I assume you got it working then, good stuff!