Recent content by dta87

Yes that is what I get when I change the field to a text format. Boblarson's post on the display value explained why I am getting the #'s with the Right([email],4) function but I am not sure if I want to change the field from a hyperlink to a text field just yet. With the amount of data...

I edited my previous post

Thanks for the help

Here you go xtest.xtest@gmail.com com# xtest2@yahoo.com com# This is the result of the query with the Right([email],4) function. Like I said the 28 records that return the correct ".com" do not have a mailto: association in the edit hyperlink field. the other 580 records do.

I understand and I had bogus e-mails in my previous reply but this forum kicks back my post saying I am not allowed to post e-mails at this time (or e-mail without the hyphen)

Yes it is a hyperlinked field. When I run the expression -- Right([e-mail],4)-- it returns "e-mail address" com# for all but 28 records. When I try to edit the hyperlink for the 28 records that do not show up with the "#" as the last character it does not have an mailto e-mail address linked to...

I inherited the database so 99% of it has not been entered/developed by me. I tried the Right function with 4 as the string length and for 95% of the entries it returned "com#" or some variant of the last 4 characters. I am not sure where the # character is coming from since when I highlight...

I tried this and because of the extra (hidden) characters this just returned the truncated list

Originally I was just trying to do a like "*.com" for the criteria but after some further investigation it was found there are some extra blank characters at the end for most of the e-mail addresses that is why it was returning a truncated listing. I ended up using this expression to automate my...

I am running a query that gives me a listing of various e-mail addresses tied to a specific project. I need to filter out all the ".com" addresses. If I run the original query and then do an "ends with" filter on the results it gives me the correct listing. If I put a "like" condition into...

That is what I figured (the need for a form). I was just trying to be lazy since we have hundreds of entries to make for each product we have, the easiest way to update the database would be to take the adresses from an excel printout and paste them into the table. With a form it would still...

I am trying to modify someones existing Access database that has multiple years worth of data. There are no forms in the database as it is built only with tables and queries (and the few reports that I have been able to add). Inputting data into this database has always been done manually...