Search results for query: *

Craig... already back with another question... I need to bump the elapsed time values up one dataset id, for example, the difference between dataset 2 and 1 is now associated with dataset 1. I need it to be associated with dataset 2. Furthermore, I need the elapsed time for dataset 1 to...

add that is, haha

Craig, This seems to be working well! Thank you very much for your help... I may be asking questions later in the day as I ass to this base. Thanks Again! Chris

WOOPS! sorry i responded without seeing your modified code, will try that now.

Craig, Thanks for your help... Upon entering the code for the first query, and attempting to run it, I get the message "Wrong number of arguments used with function in query expression 'CInt(RIGHT([DataSetNumber]))'. My Code as entered into the sql dialogue is: SELECT *...

not to be ignorant... where do I enter the "select information"? thanks for your help

I was forwarded to this forum, so I figured I should repost my original quaestion: I am developing a database for a process for which we take samples at multiple times. So I have multiple processes (test1, test2, etc), with multiple samples for each test (-01,-02,-03) I have a table of the...

thanks, leslie will do

Access Database Query Question I am developing a database for a process for which we take samples at multiple times. So I have multiple processes (test1, test2, etc), with multiple samples for each test (-01,-02,-03) I have a table of the form: TEST ID........DATASET...

.4, 5 and 8 would all be measured relative to 0. in other words .4 hours have passed since the experiment started, and 5 hours have passed since the experiment started.

k... thanks skip... I am developing a database for a process for which we take samples at multiple times. So I have multiple processes (test1, test2, etc), with multiple samples for each test (-01,-02,-03) I have a table of the form: TEST ID DATASET ID TIME OTHER DATA...

Skip, This is exactly the question I meant to ask.... how do I perform that calculation through a query, when I want it performed on the same field across different data sets. Thanks

I am in the middle of converting a somewhat complex spreadsheet layout into a database. The spreadsheet consists of a large amount of raw data entry, and then a large amount of calculations. The problem is, some of the calculations rely on absolute fields. I have figured a way around this...