jclast

	finding the max date in a record 17 Years Ago 17 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey, I've got a databae in which each record has seven dates associated with it, and I need to pull out each record's ID and its associated most recent date. Here's my first attempt, but Access doesn't like it at all. [code]SELECT id, MAX(initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate6) … Databases mssql 0 1 95
	Cant' figure out where my syntax error is (Access query) 17 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks! [code]SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority FROM afmMain AS a INNER … Databases microsoft-access 0 0 54
	ASP.NET 2.0 Invalid attempt to FieldCount when reader is closed 17 Years Ago 17 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hi, I'm new here, but I'm hoping that you guys can help me out. I'm using ASP.NET 2.0 (C#), and I'm having a problem binding a DataReader to a DataGrid. If it makes any difference my IDE is MS Visual Web Developer 2005 Express Edition. [code]System.Data.OleDb.OleDbConnection dbConnection = null; string … Web Development asp.net 0 1 205