I have a report containing employee and project information. The problem I'm having is that the format my boss wants I have not been able to solve.

Right now I have all the project info in the detail sectino so it displays like this

lblProject 1
lblProject 2
lblProject 3
lblProject 4

I need it to display like this

lblProject 1
             2
             3
             4

The lable and the first record have to be on the same line. Is there a way I can only show the label (lblproject) for the first record?

Suggest you create a temp table of the data, delete the redundant info and then use temp table for report

Cheers Ray

Its not that I am trying to weed our redundant information in a table. Its a label that is on a report that is in the detail section of the report and I need it only to show up for the first record. My boss wants the first record and the label of that section to be on the same line, so it looks like this

Relevant Experience: 1
                      2
                      3
                      4
                      5

and right now it shows like this:

Relevant Experience: 1
Relevant Experience: 2
Relevant Experience: 3
Relevant Experience: 4
Relevant Experience: 5

Relevant Experience is a label on the report. I tried using the finding the record number but I was not sure of the code to use. But I keep getting Run-Time error 2593: THis feature is not available in an MDB.

If the project number itself is in a textbox, e.g. txtProjNo, and the corresponding label is called, e.g. lblProjNo, you could do this on a report's detail section's ON FORMAT event

Me.lblProjNo.Visible = (Me.txtProjNo = 1)

This will make it invisible except for when the project number is one.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

What I am doing is where you can select an employee from a combo box on a form and then a list box populates with with all the projects that employee has worked on. Then I am using:

DoCmd.OpenReport "rptCustomResume", acViewPreview, , strFilter

to open the report and strFilter is a string that has all the projects that where selected in the list box.

that looks like this.

[EPRproid] in ('1','2,'3')

And the projects are listed in alphabetical order on in the report.

So I dont know if there is a way to take that string and figure out which one comes first from alphabetical order or if there is a way to just find the first record. I have had no luck yet.
Thanks for the Responses.

I still think it is easier to collect the info you need in a temp table with 2 columns: e.g. ProjectID & Info.
Arrange the Info data in the order you require and then add the ProjectID text in record 1 only.
Use this table as the basis of the report.

Cheers Ray

I finally got it. I used a text box, txtCount, that did a running sum of the records and then used this code to diplay the label where needed.

If Me.txtCount.Value = 1 Then
    Me.lblProjects.Visible = True
ElseIf Me.txtCount.Value > 1 Then
    Me.lblProjects.Visible = False
End If

thanks for the help