I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this:
The table has many, many values between about 1900 and today. I would like to make a table like this:
1900 - 1909 23.6
1910 - 1919 64.3
1920 - 1929 73.1
Again, I'm using Access 2010. Any help would be massively appreciated.
I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
What's the smartest way to keep regular backups of Microsoft SQL Server databases stored remotely? [more inside]
I'm looking for help with either SQL or with MS Reporting Services; not sure which, to be honest. I have a table of people (userID, username), a table of vegetable(s) each person bought (userID, vegatableID), and a table of fruit(s) each person bought (userID, fruitID). I'm trying to develop a report that has column A = name, column B = vegetables bought, and column C = fruits bought; I'm running into problems. [more inside]
Trying to make the case against
Drupal and find a ASP .NET CMS solution. [more inside]
What DBA certification should I pursue? MS, Oracle, something else? [more inside]
Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode
of the values that it's grouping, when I want averages in other multiple fields? [more inside]
Attention SQL gurus
. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
Say I have a database
there is a table called
In this table is a field named
. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]