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 dencom 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: johnrowse
  • Content: Threads
  • Order by date
  1. johnrowse

    StDev error

    Hi I have a weird error, when using the StDev method on certain number of values. In the spreadsheet itself, using the formula StDev() on: 1.428,1.428,1.428,1.428,1.428,1.428 [(x6)] = 0 CORRECT 1.428,1.428,1.428,1.428,1.428,1.428, 1.428 [(x7)] = 0 CORRECT In VBA...
  2. johnrowse

    DataGridView + Dataset From Mutiple Tables

    Hi I can create a DataGridView bound to a datatable, which queries a single table, or even multiple tables via a dataset (xsd). I want to use a query to return data from a foreign table, where a related price is held. I need to display this [readonly] price, so the user can make the right...
  3. johnrowse

    Distinct Order By

    Hi I know i must be missing something obvious, but i have been trying to get the following to work. Below is my ideal, but i understand it doesn't work like this. If i add dLastVisited to my select distinct statement, no longer will i only return distinct lSamplePointIDs. All I need is the...
  4. johnrowse

    Distinct Order By

    Hi I know i must be missing something obvious, but i have been trying to get the following to work. Below is my ideal, but i understand it doesn't work like this. If i add dLastVisited to my distinct statement, no longer will i only return lSamplePointIDs. Can anyone let me know where i am...
  5. johnrowse

    file.exists = false

    Hi I have the following in my smart device app, but I don't understand why file.exists() returns false, despite the fact that the app can read the file without issue (so the app can find it, and even access it), if I comment out the 'exists check' beforehand... If Not...
  6. johnrowse

    Limiting specific records within a query

    Hi Does any one know of a way to achieve the following? I have a query that returns the results I want, except there are duplicates due to a related table that can have many related records. I am looking to ensure only one record is returned for any found [tblPump.lPumpID] ordered by...

Part and Inventory Search

Back
Top