Search results for query: *

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. 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...

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...

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...