on NoData, show value in table

  • Thread starter Thread starter Song Su
  • Start date Start date
S

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
 
Song said:
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.
Click to expand...


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"))
 
Works great! Thanks.

Marshall Barton said:
Song said:
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.
Click to expand...


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"))
Click to expand...
 
Back
Top