Recent content by IFORD

Greg, That work, but can you tell me why I'm missing 5 names instead of getting 2000 names I got 1995

When I change my code to yours I get no names at all and I should tell you that my query1 has 5100 names and mailnet has 3100

I have two table that have a field call name I would like to compare them to see the names that do not match up. One table has 5100 and the other table has 3100 I need the 2000 name that is in the first table and not in the other table, I have tryed unmatch query and get nothing and I have a...

Thank worked thank you I just change the 15 to 42

Leslie, This is what a put in a select query and i get a error SELECT MID([FIELD1], 15, length([FIELD1])) FROM STANMARTINFORDNAMESREMOVED I get a undefied function 'length' in expressin error

EVERY NAME START AT THE SAME PLACE

I have a field1 that has this infor in it E201 1 1 3 STEPHEN H LIGHT I need a field that just has the stephen h light Can someone tell me how to make a query that will just give me that information I have 5179 record and...

THANKS THAT WORKS

Thank you for you help, when I tryed your code I get a data type mismatch in criteria expression and I can not figure out why Do you have any ideas

I have a query that has information from two different table on it importcustomer and tblcustomer I would like to compare the phone numbers This is what I have: SeLECT IMPORTCUSTOMER.[NAME ID], IMPORTCUSTOMER.RESIDENCEPH, tblCustomer.RESPHONE, IMPORTCUSTOMER!RESIDENCEPH Like...

I have tried to but this in my word form and I keep getting the mail failure - is your mailbox too full msg. Can you please tell me what I'm doing wrong Thank you Irene

I would like to have a button on a word form that when the person fill out the form. They just have to hit the send but and it will come back to my emai address. I have a marco button but I can not figure out the code to make it work. Thank you Irene

Yes it is, sometimes I just word things wrong and this is one of those times. I'm really looking for names that are not duplicates. And when I run this query I have names come up like childrose that should not be on the list SELECT IMPORTCUSTOMER.*, IMPORTCUSTOMER![ADDRESS 1] Like...

I'm check for duplicate names in a query that has 2 tables base on last name fields for each table in some cases its listing as a duplicate name but the fields are exactly the same but the query said it a duplicate. And I can not figure it out example importcustomer lastname childrose...

when i can and paste this in my sql i get a characters found after end of squl statement and it highlights SELECT ... IT HAS BE A LONG TIME SINCE I HAVE DONE ANY WORK WITH MY DATABASE QUERY.