Solved finding the last record of each group (1 Viewer)

[Jimal]

@theDBguy yes u r right - I have kept in group footer only
pls consider my ignorance...
How can I insert a iif clause in the report?? can u mind explain

 

[theDBguy]

@theDBguy yes u r right - I have kept in group footer only
pls consider my ignorance...
How can I insert a iif clause in the report?? can u mind explain

Maybe I could give it a try and show you, if you could post a sample db with test data.

 

[IbrBadri]

Hi,
On your case the remarks should be in the class table not in the name table.
Then you can issue the name report grouped by the classes, and at the group footer of class report show the remarks.

 

[Jimal]

Thank you friends I resolved the issue with the comparison of Group count with Row count

 

[theDBguy]

Thank you friends I resolved the issue with the comparison of Group count with Row count

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.