Getting MAX() Score

Dec 8, 2004

I have an access DB with games scores recorded in it. I want to get these values out into an ASP page. The basics are easy, but if a user has submitted more than 1 score, I want to extract just their highest result. This is my code:

Code: SELECT email, MAX(totalScore) AS highScores, playername, level01, level02, level03, level04, level05, lives, buildBonus FROM tbl_xmas2004 GROUP BY email

But Dreamweaver doesn't like this! Any thoughts? I have also tried creating Queries in Access and using these in Dreamweaver - however, Dreamweaver also refuses to use Joins? Or perhaps that's my code?

Code: "SELECT tbl_xmas2004.playername, tbl_xmas2004.email, tbl_xmas2004.level01, tbl_xmas2004.level02, tbl_xmas2004.level03, tbl_xmas2004.level04, tbl_xmas2004.level05, tbl_xmas2004.lives, tbl_xmas2004.buildBonus, 2004MaxJoin.MaxOftotalScore FROM tbl_xmas2004 INNER JOIN 2004MaxJoin ON tbl_xmas2004.email=2004MaxJoin.email"

View Replies


ADVERTISEMENT

Using A Form To Score Yes/No Questions

Feb 9, 2005

I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.

View 7 Replies View Related

Test Score Ranges

Feb 13, 2008

Hi all

I have a bunch of student test scores. The test is scored out of 100. I want to COUNT the scores (ie I want to know how many kids scored 50 etc...). This is easy enough except the crosstab query will be very wide ie 100 columns.

I cant seem to reduce the size by grouping them into ranges (ie count the number of kids that scored between 50 and 60 in a cross tab. I've tried variations with select queries but without luck.

Maybe there is a way to code it.. and then show it on a report??

Any ideas?? Thanks

View 7 Replies View Related

Calculate A Grade Score From Another Table Criteria

Dec 27, 2007

dear all;

i've a table #student like

studentID score

Sminth 88
samantha 76
Williamv 45
martell 78

and i also have a #grade table

Grade Start end

F 0 45
E 46 55
D 56 65
C 66 75
B 76 85
A 86 100

and my question is,how to calculate the student table's grade value?
i want the result like below..
#studentID score Grade
Sminth 88 A
samantha 76 B
Williamv 45 F
martell 78 B

anyone can help me??thanks alot

regards


martell

View 12 Replies View Related

Reports :: Sort Report On Impact Score Column

Sep 8, 2014

I have an issue sorting the results on my Access 2010 Report. Here are the details:

- Report Record Source = "Portfolio Ranking"
- Portfolio Ranking is the name of a query
- The query includes a calculated field called "Impact Score"
- FYI: this is a web database (not sure if that limits what I can do)

I want to sort the report on the Impact Score column. However, when I view the query calculation for Impact Score, the "Sort" field says "(not sorted)" and it's greyed out, so I can't select Descending as desired.

View 3 Replies View Related

Forms :: Merging Attendance In School Report Card And Also Picking Highest Score

Feb 7, 2014

I want to have a report card where I can have attendance embedded in for each students and also the highest score for each class each session.

View 4 Replies View Related

Returning Value Of "score" If Field Is Numeric

Jul 17, 2007

I am pulling some information, and I am needing a report to show the value "score" if the field is numeric, but if it is not numeric, retain it's original value. for instance if the field is 1234 it needs to show on the report as "score" but if it is MSP it needs to say MSP.

Any help would be greatly appreciated.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved