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 bkrike 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: *

  • Users: jotb
  • Content: Threads
  • Order by date
  1. jotb

    Query

    Hello All: I created a query in design view. I used the following fields: Date,DST,DIFFB,DIFFA1 and [DIFFB]-[DIFFA1]. I typed in a specific date and DST in the criteria. I ran the query and the new field expr1 calculated the differences using that expression [DIFFB]-[DIFFA1]. There were 5...
  2. jotb

    THIS IS A TOUGH ONE

    Hello ALL: I was wondering if it's possible to query the following and if yes, what type of formula is needed? Here is an example of my database fields and type of data DATE (FROM 06-DEC-00 TO 20-APR-03) Each date has up to records. TRK Text AQU,BEL,SAR) SUR Text (M,ID) SEX...
  3. jotb

    Help Please on query

    Hello All: I need to find an average. Within one field I have data that is as follows: 6.0, 6.5 7.0 (FIELD NAME IS DST). Another field called 1FR has data like 2154, 2212, 2346. I previously ran a query using the field (1FR) and the fIELD (DST).When I averaged the datasheet view had an...
  4. jotb

    Change data

    Most of the data I have collected is in number form. An example would be 11070 but I need to change that 11070 to 7070. The 11070 stands for 1 minute and 10.70 seconds. I need to change to 70.70 seconds. I'm not working with decimals but I want the data to look like 7070 instead of 11070. I have...

Part and Inventory Search

Back
Top