on NoData, show value in table

[Song Su]

My report recordsourse is based on qrystudent where i have 2 tables.
'duration' table has 2 fields [from] and [to].

on NoData event of the report, I want to give message like 'You have not
logged in during ' [from] and [to]

If NoData, how can I give message include fields value in 'duration' table?
'duration' table has only one record.

Thanks

 

[Marshall Barton]

My report recordsourse is based on qrystudent where i have 2 tables.
'duration' table has 2 fields [from] and [to].

on NoData event of the report, I want to give message like 'You have not
logged in during ' [from] and [to]

If NoData, how can I give message include fields value in 'duration' table?
'duration' table has only one record.

Use a text box with an expression like:

=IIf(Report.HasData, Null, "'You have not
logged in during " & DLookup("[from]","Duration") & " and "
& DLookup("[to]", "Duration"))

 

[Song Su]

Works great! Thanks.

My report recordsourse is based on qrystudent where i have 2 tables.
'duration' table has 2 fields [from] and [to].

on NoData event of the report, I want to give message like 'You have not
logged in during ' [from] and [to]

If NoData, how can I give message include fields value in 'duration'
table?
'duration' table has only one record.

Use a text box with an expression like:

=IIf(Report.HasData, Null, "'You have not
logged in during " & DLookup("[from]","Duration") & " and "
& DLookup("[to]", "Duration"))