Generating a report from more than one query

lic023 · March 31st, 2004, 09:22 AM

Hi

I want to generate a dynamic report that based on as specific set of queries.

At the moment each query exists as as subform in the report but some queries contain no data. Therefore I need the report to say something like (data contained within are from survey forms) "no replies to this question".

Could I use an IIF statement or would a VBA function work better. Would prefer to use VBA unsure how to go about it.

Many thanks

Steven · March 31st, 2004, 06:46 PM

Your best bet would probably be using the NoData event.
For example, you could have a label that is dependent on if there is data or not.

such as:

Code:

Private Sub Report_NoData(Cancel As Integer)
LabelX.Caption = "No replies to this question"
End Sub

Or have that label's visibility be based on the NoData
Eg: have it as Visible=False, then for the NoData event, have

Code:

Private Sub Report_NoData(Cancel As Integer)
LabelX.Visible = True
End Sub

I am a loud man with a very large hat. This means I am in charge