Making serial in report:

  • Thread starter Thread starter 123
  • Start date Start date
1

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


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)
 
Back
Top