Making serial in report:

[123]

Making serial in report:
To make easy serial on Each Group You can use the following code
Control source =1
Running sum = over group
I there any way to control this serial if is there condtion for example if
job child or infant don't put serial for this person
example
serial name job
1 a dr
b infant
2 cd dr
sd child
3 sd dr
and so on
I hope u understand my question:

 

[Marshall Barton]

Making serial in report:
To make easy serial on Each Group You can use the following code
Control source =1
Running sum = over group
I there any way to control this serial if is there condtion for example if
job child or infant don't put serial for this person
example
serial name job
1 a dr
b infant
2 cd dr
sd child
3 sd dr
and so on

First add a text box named txtAdult to the detail section.
Use an expression like:
=IIf(job = "infant" Or job = "child", 0, 1)

Then, instead of setting your serial text box to the
expression =1, set it to:
=txtAdult

To hide the serial number for the child type records, add a
line of code the detail section's Format event:
Me.txtSerial.Visible = (Me.txtAdult = 1)

 

[123]

Thank you very much for the help
Easy code (Strong-Excellent-Fine) work, thank you