Selasa, 30 September 2014

[MS_AccessPros] multi colums report

 

 I have a multicolumns report, which is the labels (column headings) are displayed on the left side of the report,
and the data is printed next (on the right side) to the labels. As an example shown below.

-----------------------------------------------------------------------
                         Company1    Company2    Company3 
Current Month  09/08/2014    09/08/2014   09/08/2014 
Line1 Data        ABC              DEF              GHI

Prior Month      08/08/2014    08/08/2014   08/08/2014  
Line1 Data       STU               VXYZ            CBA
-----------------------------------------------------------------------

The procedure below is the code that I use to generate the report above.

 

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo ErrorHandler

Dim i As Integer
If Me.Left < 1.75 * 1440 Then
    Me.NextRecord = False
    For i = 1 To 5
        Me("txt" & i).Visible = False
        Me("lbl" & i).Visible = True
    Next i
Else
    For i = 1 To 5
        Me("txt" & i).Visible = True
        Me("lbl" & i).Visible = False
    Next i
End If

ExitProcedure:
Exit Sub

ErrorHandler:
    MsgBox "Error Number: " & Err.Number & vbNewLine & "Error Description: " & Err.Description, vbExclamation
    Resume ExitProcedure
End Sub


Now, is it possible to format the report, insert the Prior Month before the Current month,
so the data will be printed as a column, side by side, next to each other like this.

 

-------------------------------------------------------------------------------------------------------------------------

Prior Month    Current Month    Prior Month     Current Month   Prior Month    Current Month  
Company1     Company1         Company2       Company2        Company3      Company 3 
08/08/2014     09/08/2014        08/08/2014      09/08/2014        08/08/2014     09/08/2014 
STU                ABC                   VXYZ              DEF                   CBA               GHI

--------------------------------------------------------------------------------------------------------------------------

Phucon.

__._,_.___

Posted by: saigonf7q5@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar