S
ShinyTek
Guest
Hello, I am working on a mailing label report from a query that contains names and entry IDs as fields. Most of the names have many entries that correspond to them such as:
Person1 may have CG114, CG115, FV213, and FA345
Person2 may have CG127
Person3 may have FA234, FA235, and FA236
where as the fields in question are txtLastName, txtFirstName, and txtCategoryID. There are other fields but those are not important at the moment. I also have an expression that evaluates those category IDs with nested IIf statements with Left statements which works fine but the query might have that person's name 10 tens with ten of the results of this expression. I'd like to show the name only once in the report with only one of the results of this expression, regardless of how many records are actually returned. I've done this by putting the controls in the expression header but now I can't get the spacing right to fit in the labels. When the controls are in the detail section it works but then I have the problem of returning all the records. I either need to fix the spacing problem in the expression header or return less records in the query. I will appreciate any help with this problem as it needs to be resolved as soon as possible.
-ShinyTek-
Person1 may have CG114, CG115, FV213, and FA345
Person2 may have CG127
Person3 may have FA234, FA235, and FA236
where as the fields in question are txtLastName, txtFirstName, and txtCategoryID. There are other fields but those are not important at the moment. I also have an expression that evaluates those category IDs with nested IIf statements with Left statements which works fine but the query might have that person's name 10 tens with ten of the results of this expression. I'd like to show the name only once in the report with only one of the results of this expression, regardless of how many records are actually returned. I've done this by putting the controls in the expression header but now I can't get the spacing right to fit in the labels. When the controls are in the detail section it works but then I have the problem of returning all the records. I either need to fix the spacing problem in the expression header or return less records in the query. I will appreciate any help with this problem as it needs to be resolved as soon as possible.
-ShinyTek-
