Search results for query: *

I don't really understand what you mean. Should I remove/delete the mask? Where do I put the "numbers" then? Thanks

Hi Skip: Thank you for your response. The telephone numbers are in text, the input mask is \(000") "000\-0000 I don't understand why some of the numbers are correct and some are not, in the same document. The numbers show correctly in the table and the query but not in the merged document...

Hi: My initial problem was that after merging a document from Access 2002 to Word, the telephone numbers showed in two formats in the same document. 123-456-7890 and 1234567890. I tried Alt F9 to add to the field \# “000’-‘000’-‘0000” and also using ## instead of zeros, but nothing changed...

Hi: The phone numbers are all from the same table and entered the same way. \(999") "999\-9999! but it is text - is this the issue? But why would there be three different styles? Thank you for your time.

Hi. I have several Word mail merged documents from Access where the telephone number displays incorrectly. In a single document it displays as 1234567890 and 123-456-7890 and (123) 456-7890. Why three different styles? I have searched here and MS help online. At the moment I have in the...

Thanks a bunch PH - that works perfectly. Leslie: The two records I wanted were 1. all clients with an anniversary of 12/31 and are Profit Sharing and 2. All clients with an anniversary of 12/31 who are not Profit Sharing (e.g. 401K.) The Nz did the trick Sorry if I was unclear, I appreciate...

Hi; The problem is item 2. When Ann is 12/31/** and Type is NotPS then when it merges there are no records. If I remove 12/31/** and keep NotPS I get all my records. 12/31/** and PS work just fine Thanks, I hope this is clear enough

SELECT CLIENT.PLAN_CODE, EMPLOYEE.[First Name], CLIENT.COMPANY, CLIENT.CONTACT, CLIENT.[CONSULTANT CONTACT], CLIENT.[CONSULTANT SALUTATION], CLIENT.STREET, CLIENT.CITY, CLIENT.STATE, CLIENT.ZIP, CLIENT.SALUTATION, EMPLOYEE.MI, EMPLOYEE.[Last Name], CLIENT.ANN, CLIENT.SPECIAL, CLIENT.[year of...

SELECT CLIENT.PLAN_CODE, EMPLOYEE.[First Name], CLIENT.COMPANY, CLIENT.CONTACT, CLIENT.[CONSULTANT CONTACT], CLIENT.[CONSULTANT SALUTATION], CLIENT.STREET, CLIENT.CITY, CLIENT.STATE, CLIENT.ZIP, CLIENT.SALUTATION, EMPLOYEE.MI, EMPLOYEE.[Last Name], CLIENT.ANN, CLIENT.SPECIAL, CLIENT.[year of...

My table has Client, consultant, hours worked etc. fields Each client has a consultant where hours worked are logged. At times another consultant will work for this client and their hours are logged under their name. In my query each entry shows separately with the main consultant 60 hours...

Thank you all very much for responding. BobJacksonWcom: Your answer was exactly what I was looking for and it worked! Thanks again

Thanks for responding My fields are all numbers I just want to add the columns together Thanks

Null Values – could someone please explain this in simple language. I have tried all ways with Nz etc but I am getting nowhere. My Query has Column One (Total One) and Column Two (Total two), Column Two contains some null values. I would like Column Three to total one and two and include the...