Report Header Problem

[BigDogTroy]

I am new to using the report section of Acccess, so forgive me for not knowing the easy stuff. I am running Access 2003, on Windows XP system. I have created a report, and works fine, but when I go in and change the header information (I'm just trying to format the header), such as <dbname.field> to a heading I want to show, it changes the data in the detail section. Can someone tell me what I am missing? Also, When a value calculated equals nothing I would like for the report to show a zero, any ideas on how to make this happen? Thank you in advance for your help!

 

[Ziggy1]

Are you changing a label name or a bound control name?

You can use the nz function to put a Zero in...

Expr1:nz([Calculation],0)

 

[BigDogTroy]

The header field is a label. I notice that if I make any changes what so ever to the report, I lose data. I have no idea why. The report runs a query, the query counts the number of calls for a particular user, then displays the information. I was just trying to use the report function to keep me from having to do manaul changes everyday when the query is run (just the header portion is what i change daily). Hope this gives you a better idea of what is going on. Thanks

 

[Ziggy1]

can you post the function or even a stripped down sample of the DB with only the report and sample data?

although you want to automate the name, I was going to suggest this in the Open event of the report to let you name the report when it opens. You could also pass it from a form

Private Sub Report_Open(Cancel As Integer)

Dim rptlabel As String

rptlabel = InputBox("Enter Report Name")

' Me.lblReport.Caption refers to the name of the label on report
Me.lblReport.Caption = rptlabel


End Sub