Since you didn't specify the DB or data entry object you're using, I'll give you generic information. The "----john-----" comes from a list box or combobox (multiple items) or a textbox (single item). Remove leading and trailing blanks from the selected string, and use the text property, not the caption property. Use of % or * wildcard depends on the DB. As for displaying graphs, you don't give enough background information to answer it. How do you generate your graphs? Do you display them in a web browser or on a standalone machine? What reporting package(s) are you using? Check MSVB Knowledgebase for information about displaying graphs.