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

    StDev error

    Sorry I guess writting the problem out to myself, was enough for me to solve it. 2.39835584666591-16 is actually an incrediably small number (need to shift number by 16 decimal places to the right). This very minor inaccuracy, must be due to floating point precision rounding. I can round...
  2. 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...
  3. johnrowse

    DataGridView + Dataset From Mutiple Tables

    Thanks MajP But the 'price' is not calculated, so can I use an expression (can I use a select statement within an expression)? The main table is essentially an 'order table' and I need to display 'price' within the 'orders', so that the user can reallocate the order, if necessary, on the basis...
  4. 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...
  5. johnrowse

    Import CSV file into SQL Table

    if I was you: 1) Add an XSD to your project, with your SQL connection settings 2) Create a TableAdapter object in your XSD, pointing at the right table 3) Add an Insert Query to your TableAdapter 4)Create a Class in your project that utilises system.io.StreamReader to parse your csv row by row...
  6. johnrowse

    Distinct Order By

    George Thank you so much. It works a treat and you explained it brilliantly – you should be a teacher, if not already. Thanks again. John
  7. 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...
  8. 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...
  9. johnrowse

    file.exists = false

    Andrzejek, Thanks for you help. You were not far off, I have only just figured it out so had not had a chance to update y own question (although I still don't understand the difference). I had: "\\" & LocalUpdatePath & "\" & UpdateInstructionFileName (as smart devices have an unnamed device...
  10. 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...
  11. johnrowse

    Limiting specific records within a query

    Thank you so much, lameid Not only have you resolved my issue, you have taught me a lot about sub-queries! In case it helps others, I modified the sub-query: (Select tblPumpMovement.*,B.MaxdDateIN From tblPumpMovement Inner Join (Select lPumpID, MAX(dDateIn) as MaxdDateIN From...
  12. johnrowse

    Limiting specific records within a query

    Thanks again, lameid I have added the sub query as you suggested (I think), but now I get an error message: "Error Column tblPumpMovement.lPumpMovement is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" Adding that causes to flick...
  13. johnrowse

    Limiting specific records within a query

    Thanks for your replay lameid. My design means they are related by a mapping table, rather than directly [tblPumpMovement] As a pump can have unlimited movement, I need to return only the 'last' movement recorded for any given pump. So I have ordered by [tblPumpMovement.dDateIn] but, how I...
  14. 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