Sorting and Grouping using an expression of LEFT$

  • Thread starter Thread starter DellaCroce
  • Start date Start date
D

DellaCroce

I am trying to format a Detail Group footer using LEFT$(LS, 7) where LS is a
variable in the report and is of type string. I however get prompted for
LEFT$(LS,7) every time I run the report. Is it possible to do Sort and
Grouping on this sort of string expression?
 
Try putting LS in "[]" like
LEFT([LS],7)
and Yes you can use this for sorting and grouping.
Hope this helps
Fons
 
DellaCroce said:
I am trying to format a Detail Group footer using LEFT$(LS, 7) where LS is a
variable in the report and is of type string. I however get prompted for
LEFT$(LS,7) every time I run the report. Is it possible to do Sort and
Grouping on this sort of string expression?
Click to expand...


Two points come to mind here. First, don't forget the =
sign in front of the expression. Second, the names used in
the expression (LS) need to be a built-in or standard module
Public function or a field in the report's RecordSource
table/query, not a control or VBA variable.
 
Back
Top