Search results

Not quite, because I dont know if the athletes here are on the team displayed in the first query. Hmm... Thank you for the time:)

Yes, the first query show the sum (TotalWeight) of each team sorted. The other query the athletes individual weigth sorted. I want to combine it together for a report. When I do, it fails. Suggestions? Select into select (subquery) or?

That worked, but the results was not the right one. I want to display the TotalWeight for the teams with teamname, combined with the athetes individual weight all together. I have the 2 queries but not a combined correct one:)

I have 2 queries tha I'd like to combine and show all together, how can I do it without UNION? (Because you have to have tje same nr of columns) Deltagere (Athletes), Vekt(Weight), Konkurranse (Competition), Lagnavn (Teamname), Klasse (Class) My first query: SELECT Deltagere.Lagnavn...

I need some help here... I have 1 one to many relationship with Deltagere (Athletes) and Konkurranse (Competitions). I want to present the sum of the weights (TotalVekt) for each Team (Lagnavn) and the atheletes with their weight in the same query. The sql under shows the teams and their...

Sorry, the query is fine! I ordered the result in my report instead. Thank you very much:) Nice!

I have tried it and thats more like it. But I am not quite there yet. I modified the code a bit... It lists the athletes in the team, with the teamname and the total teamweight. But how can I get just one instance with team with that team athletes, their weight and the totalweight? Thanks for...

I want to ask the database after the teams (lag) with the athletes listed in the team with the highest TotalVekt (TotalWeight). With the code under I find the teams with the highest TotalWeight, but not with the athletes on the team and their weight combined with the totalweight of the team...

I need some help with my form design. I have multiple one to many relationship. See the picture(relationships.gif) The problem is to connect Lag (Teams) with Deltagere(Athletes) in the form. One athlete can have just one team and one team can have one or more athletes. I need to first fill in...

Here is my new design. I think this is better design and it works now, but not in my forms. Can someone help me with the form design? I would like to have 2 subforms with one to many.

Someone with some examples, please?:)

Hmm, I have learned that you must try to use one to many instead. Thats because it can be too complicated design, normalization and so on... Do you have a example with many to many with my tables? Thanks for help

2 one to many relationship forms design Hi all! I want some advice from you. I have 3 tables: Table 1: Competition Table 2: Athletes Tables 3: Team A team can have 1 or more athletes A competition can have 1 or more athletes A competition can have 1 or more teams. When I started to design...

I fixed it my self. The solution was: SELECT O.ID, O.AntallPips, (select sum(AntallPips) from trades where ID <= O.ID) AS ['Running Total'] FROM trades AS O ORDER BY O.ID;

Ok, see the example in Excel as a picture. Thats all I want:)

Ive tried that also, but it gives me wrong calculations. Any suggestions?

I need some help on this. I have a Sql here: SELECT DISTINCTROW trades.ID, Sum(trades.AntallPips) AS [Sum Av AntallPips] FROM trades GROUP BY trades.ID; The idea is to have a start number like 10000 and using the sum to sum antallpips. For example like this: 10000+The first number=Calc 1...

I want to print out some text fields with some iif statements and calculations, but I get them print out many times. I will have the print out only once. You can see it in the picture attachment. Please help me on that:)

Yes..:) Thanks! the new code that works: =Sum(IIf([GevinstTap]=True;[AntallPips]))

Hi! I need some help on If statements... =IIf([GevinstTap]=True;Sum([AntallPips])) GevinstTap is a true/false field and AntallPips is a number field. I want to calculate the Sum of all fields who are True. Can someone help me? I know it is a simple thing..but Herbertioz