Search results for query: *

Thank you very much for responding. I will try you suggestion

I have a contact database which contains three tables that I need to create a query from. The first table (Industry Companies) contains the primary mailing address for my companies. The second table (Industry Representatives) contains contact information and an address for the company...

That worked. I can't thank you enough! It will be a tremendous time saver.

I am having trouble building an expression for an unbound text field on my report. My database contains a field named Class. The class field data can be I, II, III, IV or V. I would like the results of a count for this field on I, II and III excluding IV and IV. My expression looks like this...

I am tring to run a query to change the data in a field in a table from upper case to proper case and have been unsuccessful. In SQL view the update query looks like this - UPDATE Prospects SET Prospects.LastName = StrConv([LastName],3); When I try to run the query, I receive the following...

Thank you for the help.

Thank you for the info. I am familiar with update query but am unfamiliar with the Ucase () function. Do I write:<br><br>UCase (lastname) in the Update To line?

I need to convert only the last name field in my database to uppercase. Is is possible to do so?

Thanks for the help. I am going to try Amiel and Elizabeth's suggestions.

I need to assign an ID field to our membership database. Membership is divided into chapters. I assigned each chapter a number. Is there a method for selecting the unique field for my primary key. I was considering 01-AB-XXX. 01=Chapter, AB=First two letters of members last name, XXX -...