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/
