Recent content by fregal

Hi I see, thanks for the help. You wouldnt by any chance have a good idea about how I do this? Add: I think I found it here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269599 -- Best regards fregal

Hi First of all, thanks for this resource. Second, I mostly use Access db's in my webdevelopment, and it would be great to see a new category "WWW stuff" or something. -- Best regards fregal

Hi! I would think this is elementary, but I cant find the solution anywhere... This is the case: Example: A guestbook where users write to a access db by entering text to a webform on a asp. A asp that query the access db and output the results. So far, so good - but: Question: How do I...

The_Doc_Man are you sure the expression is correct?: Ranking: 1 + DCount( "[TeamName]", "MyTable", "[TotPts] > " & [TotPts] ) I get an "invalid expression" whatever i try to do with this... Example: I put the TotPts expression in the query Q_TABLE I make a new query of Q_TABLE and call it...

Hi, im learning, but.... I downloadet the Query samples from Microsoft, and got a little further. But now I also see that the Handicap must be considered in the calculations as long as i want a ranking with these metods. I think its a bit odd that there isnt a way to just count the rows and...

The sorting is not a problem. The problem is to get a ranking number as well, so that the leading team get '1', second team get '2', etc. -- Best Regards fregal

The_Doc_Man! your suggestion makes sense, because a tie on points may happen. But, could you please help me some more? Im a newbie when it comes to use access without the help of the buildt in wizards and "drag & drop" functionality. AND I do have a attribute who counts only when there is a...

Hi thanks for replying. I will try out your suggestions. fregal

Hi I have a Access db where sportsteams register their score etc. I have a Query who output the totals, and put the team with most score on top etc. BUT I want to have a ranking number to the left of the teams name. I use this in a webreport (asp). ex: 1. Holy Eagles 50 points 2...