Which means that perhaps it should be a row, but perhaps not in this particular table ;) Database Normalization 101.
See SQL Data Types, which Number does not seem to be a member of. How you...
Type: Posts; User: copeg
Which means that perhaps it should be a row, but perhaps not in this particular table ;) Database Normalization 101.
See SQL Data Types, which Number does not seem to be a member of. How you...
Several ways to go about this, the first and more proper being that total should not be a row (and if it is should be a row in a different table - one of my pet-peeves with Access because it behaves...
I'd recommend browsing something like W3 Schools SQL. Shouldn't take too long to learn the basic queryformat to accomplish things like this as the syntax is fairly straightforward (the queries can...
Try surrounding the column name with double quotes
boolean foundResults = statement.execute("SELECT Market, \"Oct 2010\", \"Oct 2009\" FROM REVPAXperDEPT");
Never had to connect to Access, but typically you need the JDBC driver to create a database connection (sun has a tutorial online for JDBC basics). A quick google turned up suggests in other...