Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrisd9

    Advanced Calculations?

    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...
  2. chrisd9

    Advanced Calculations?

    add that is, haha
  3. chrisd9

    Advanced Calculations?

    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
  4. chrisd9

    Advanced Calculations?

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

    Advanced Calculations?

    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 *...
  6. chrisd9

    Advanced Calculations?

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

    Advanced Calculations?

    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...
  8. chrisd9

    Advanced Calculations?

    thanks, leslie will do
  9. chrisd9

    Advanced Calculations?

    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...
  10. chrisd9

    Running Difference

    .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.
  11. chrisd9

    Running Difference

    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...
  12. chrisd9

    Running Difference

    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
  13. chrisd9

    Running Difference

    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...

Part and Inventory Search

Back
Top