Hi, Try: Like "[EMAIL PROTECTED]" in the WHERE clause of your query.
Bryan --- In [email protected], "chrisman052003" <[EMAIL PROTECTED]> wrote: > I have a table, tblPhone, that contains 2 fields. PhoneType and > PhoneNumber. The data type for both are text. I want to print a > report that shows work phone number and email accounts. Since both > phone numbers and email accounts are in the field PhoneNumber, how > would I write something that says if field phone number has > characters, the @ symbol, then characters, then show that record. > As far as I have gotten email:IIF(IsNull([phonenumber]= I can't > figure out how to say [EMAIL PROTECTED] > Thanks Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
