Dear all,
Would you tell me how to solve the following two problems in an access file
upon preparing report form:
a) I have written an IIf function for a string field at the beginning of
group row of a report form as below:
sss is a string field with 2 characters;
the function is = IIf([sss]="1", "yes","no")
Problem: the report only shows the "#¿ù»~"
If the function is =IIf([sss] Is Null, "yes", "no"), the result is
only showing "yes" for all records.
b) How can I list out the records on the report with serial numbers if
there is serial numbers for the records in the table?
Thank you!!
Peter