Search results for query: *

I'm using SQL SERVER 2000.

Thanks LKBrwnDBA, it's working now. Another question came up, what if I want to concatenate the "comments" together in the new merge row. Is that possible?

It's not seem to be work, I actually forgot to mention "comment" field which contain a random txt. Would that cause a problem?

I have a table which contains LoginID, WC, ProjectID, Mon, Tues, Wed, ......,Sun. More than one row can have the same LoginID, WC and ProjectID and if that is the case then I want to merge these rows' value together. Can anyone show me a sample code of doing this? The Values in Mon - Sun column...

Is there a way to only extract part of the values from a column in a Select statement? e.g. "Name" field contain value "JOHN GRANT" and I only want to extract the first 4 characters "JOHN". Any suggestions?

Thanks r937!

Hi, currently trying to group all the rows with a column containing matching dates and sum all the rest of the columns together. Can anyone suggest a good SQL sample to do this. The Data looks like this: Currently: 24/08/07 7 1 2 2 24/08/07 8 2 1 1 21/08/07 3 2 1 1 I...

Thanks Lameid, found the bug. There's two person with the exact same name.

I have this Access function to sent out emails to a list of people automatically using contacts in Outlook. When it try to send to a person with two different email address outlook would throw an error message but if I just ok that, the function would carry on happily. But for reason, when one...

Duh, I feel so slow today. Thanks again Remou!

Actually I've got another problem related to this. Is there a way to add spaces and return characters to the count?

Thanks Remou it works!! No wonder it was not working before, I was using the len() function in the module part instead of control source.

Can any show me a way to create a display for counting the number of characters being entered into a textbox (real-time) on a form.

Thanks for the advice.

That is perfert, just need to little tweaking. Thanks again

Right I declare frm AS Object. But is "CurrentProject" available in ACCESS 97? It doesn't seem to recognise it?

Can you please tell me what frm is declare and set as? Thanks

Hi, I would like to locate the occurrence a certain table and query in all Forms. Is there a faster way than going into Form design mode and check the properties to see what table or query is used?

Thanks Remou. Everything solved!

Thanks Remou that really helped. One more problem, the email generate doesn't include my email signature. Is there a way to get it in automatically?