Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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