Search results

Hi, The Solution that works for we is the following. Thx for you help much appreciated. I have learned a lot. SELECT T.casenumber, T.actionDate, T.NextDate, T.action, DateDiff("d",actionDate,NextDate) AS Expr1 FROM (SELECT casenumber, actionDate, action, ( SELECT MIN(actionDate)...

I think it's because my case_no field is in text. The case number field in the database its format is i.e. 000021254L2. That's why it returns a error I believe.

See the attachment to see the error I receive in my real database when I run the query. I have tried to fix it but can't find the solution. In SQL the expression I have is : SELECT...

It works in the file I uploaded but whenI try it in my real database it doesn't work. It might be just a little thing that I have to find out. Thx.

Thx Plog for your reply. In the query, the expression field returns the value error. I will try to figure out why. I think we are close to something.

I have uploaded a sample of the file to provide a better example. I don't know why in my initial post the table didn't format correctly. I'm bad with PHP I guess. I don't think the DMIN will work as I have other transactions before the UMAIL action - see case number 2 and 3 . Sorry for the...

Hi, I have been googling around for this question but I'm still lost. I have the following table: case number action date 1 calll 1/1/2014 1 UMAIL 1/1/2013 2 report 3/5/2015 2 umail 4/6/2014 3 final 6/5/2011...

I found a way to make it works with Cross Tab. However Access trunks the memo field. Is there a walkaround I can do to have the entire information in my cross tab. here the SQL : TRANSFORM First(ROD.ROD) AS FirstOfROD SELECT ROD.id FROM ROD GROUP BY ROD.id PIVOT [ROD]![ROD number]; ROD.ROD...

I think the link you provided, mentions that is limited to 255 characters and one of my field is a memo. I cant let access trunck this field:(. I will look in the cross tab query first.

Hi, Not sure I have to pass by the concatenate build-in fonction. I have a table such as : col 1 col 2 (is a memo field) 1 a 1 b 1 c 2 d 2 e I want the output to be like this with new columns : col 1 col2 col 3 col 4 1 a b c 2...

Thank for your response. I decided to go with Tab form instead but the defaut view is datasheet and when I switch the view to single form, the tab form shows the datasheet view again. How can I fix it.

As the queries dont have the same number of fields, I guess I must go with the report I guess. Do you have more info how to do this such as links our tutorial as I'm not very Knowledgeable on report.

Hi, I have a database from sharepoint which has 250 fields based on a survey. I imported the database into Access where I made 10 queries. I want to know is there a way to display those 10 queries in one queries or in one form. Given that some queries has result to display and others...

Thx AccessMssql. It works perfectly. I used : SET [Copy Of matched uptake_OASP1208].GIVEN_NAME = Replace([Copy Of matched uptake_OASP1208]![GIVEN_NAME],"mrs"," ") WHERE (((Left([Copy Of matched uptake_OASP1208]![GIVEN_NAME],3))="mrs"));. I will try the Ltrim function to remove spaces.

Hello, I have a field with given names such as : Mrs Gordon Mrs Doyer King Larry I would like to remove only the Mrs title in the field in order to have only the given names without the title Mrs : Gordon Doyer King Larry So far I tried a update query : UPDATE [Copy Of matched...