General information
Category:
Coding, syntax & commands
Hi All,
I want to group items in a report by not a field but
a part of field. For example useid is 12 digit number
and 5th to 6th position indicate the are of this user.
I want put sql code like Group by substr(userid,5,2).
I tried that but VFP 6 does not seem to like it.
Column not found error message comes on. Off cause
this could be FoxFire's(I am beta testing Fox Fire)
limitation that I don't know about.
May be my approach is not permissable. If so is there
any trick I can use to achieve this end.
Thanks for your help always.
Aiko Ichimura
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only