Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
David Schurmann
Starting Member
3 Posts |
 Posted - 2008-05-20 : 01:23:12
|
| I say basic in trust that it is for you guys, clearly not for me. I am a completely new Access user and needless to say I need some help.I am trying to get a column to show a calculation of two seperate columns. The catch being that the two other columns have characters in them not values. Say the table name is tableIn the table I have two columns namely column1 and column2I want the characters in each column to be like so a=1,b=2,c=3,d=4 in column1 in column2 e=5,f=6,g=7,h=8.then in a new database I would like to do a sum saying column1*column2 on a choice of a through h. So you should be able to use a drop down list of the two choices and the answer should be displayed in a "result" column that I can use somewhere else.Hope that makes some sort of sense |
|
|
David Schurmann
Starting Member
3 Posts |
Posted - 2008-05-20 : 01:49:32
|
| Ok got this farSELECT SUM(column1*column2) as score FROM table;Then do I use a where clause? |
 |
|
|
|
|
|
Basic Update Statement using 2 records for dummies