hello, i can't seem to have a hold of the right syntax in the formula workshop>sql expression. i can't even write the correct syntax for just selecting a field from a table. what's the right format of syntax in crystal reports (sql expression)? oh, i'm a new member by the way, seasons greeting to you all P.S. pls help me, i really need it now. i'm at the office ^^;