decimaler i en rapport!

Hi Rasmus, Hows it going with your dB, hope you found a solution to the little problem?

Concerning THIS question! If you are using a query for the reprt then you should be able to use an IIF combined with a format!

Hey Terry!

I think i found a solution to the other problem :-) I just cannot find one to this problem :(

I have in my repport the data from the table resultatTabel. The table have the following rows: ID (PK), Licensnummer, Turneringstype, Score and Indgange.
On my repport i have a sql-statement where i have SUMS of Score, SUMS of Indgange, Groups of TurneringsType and Groups of Licensnummer. Those Sums and Groups are added to my repport as the fields: Turneringstype (pageheader), SumOfScore(detail), SumOfIndgange(detail) and CountOfTurneringstype. I have then added a textbox where i make a calculation ( =[SumOfScore]/[SumOfIndgange]/[CountOfTurneringstype] ). This textfield is called Summering.

The repport seperates the pages depending on the TurneringsType. Then I will get the results of each Turnering written. I just cannot figure out how ( or perhaps where ) i can "filter" those pages.

I think i can make a sql-statement where i can seperate one kind of turnering (with %like%). But how or where do i make this sql-statement in a textbox?

PS: my (updated) DB is at: http://www.abc72.dk/temp/db5.mdb (671 KB)

\\Hansen

Strange, I can NOT download the dB, it just starts opening it from the link! Can you compress and zip it and send it to me dktebrsa@europe.lego.com

You can use VBA code in the report.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim dResult As Double

    dResult = [SumOfScore] / [SumOfIndgange] / [CountOfTurneringstype]
   
    If InStr(1, DLookup("Beskrivelse", "TurneringsTabel", "ID = " & [Turneringstype]), "3 Bande") > 0 Then
   
        Me.Summering = Format(dResult, "#######0.000")
    Else
   
        Me.Summering = Format(dResult, "#######0.00")
    End If
   
   
End Sub

u amaze me once again :-)


thx Terry

Your very welcome :o)