Search results for query: *

Hi all, what is the difference between Crystal reports XI et Business Object XI ? TIA.

Thank you PHV, It worked great.

Hi all, I have mytable with 2 fields ( Name1 and Name2 ) and want to get Newtable or newQuery with 1 field called Name3: blank and blank2 are fixed. if Name1 = blank then Name3 must = ccccc if Name1 = aaaaa then Name3 must = aaaaa if Name1 = blank then Name3 must = blank and not blank2...

Thank you, It worked fine after testing but I must built a long lookup table with many values.

Can somebody gave an example how to built look up table with a join ? Thank in advance.

Hi all, I have a select SQL with more than 13 IIF inside that always gave an error message : Complex expression WHY ???? Maybe Access 2000 can handle only 13 IFF, Please give some advices or ideas how to solve the following Select : select iif(mid([fieldName],1,4)="0602","aaa"...

Thanks a million Golom and CMP, Golom, I try this code, it works fine but I don't know why the part to create a newtable did not work so I comment out. Sub Unnormalize2() Dim rstoldtable As DAO.Recordset Dim rstnewtable As DAO.Recordset Dim db As DAO.Database Dim tdf As DAO.TableDef...

Golom, You are right, but that's no deletion for a moment, Thanks again for your very advice.

CMP, I have no idea how to modify your code to get the result in a single record in newtable: amount1 amount2 amount3 amount4 amount5 amount6 10000 20000 30000 40000 50000 60000 TIA if you can help me again with your new codes.

Hi Golom, I used the autonumber called ID field to update that works fine update mytable set field1 = "OK" where ID = 1; update mytable set field1 = "yes" where ID = 2; ...... ...... ID field come with autonumber automatically. mytable before updated with field1 empty ID field1 1 2...

Hi Golom, You are right with the result you get with 3 records but I want to have,it is always in the single record,means 1 line 1000 2000 3000 4000 5000 6000 TIA

Thanks a million CMP, It worked fine your code, I need your help again, what happens if I have more than 2 records in an oldtable oldtable with 6 records amount 10000 20000 30000 40000 50000 60000

Thanks for your prompt reply, Sorry for not explaining clearly, in fact a second table (TBL B)is empty, this means is to transfert 2 records from an oldtable (TBL A)to become 1 record with 2 fields in Newtable (TBL B) instead. That's no relation between 2 tables

Hi, I am a novice in VBA - Access coding : I have an oldtable in Access oldtable ( 1 field ) called amount with 2 records. amount 10000 (1st record) 20000 (2nd record) How to get a Newtable with 2 fields ( amount1 amount2 ) already created ? newtable ( 1 record with 2 fields ) amount1...

Hi, Normally we can update with field name that existed in the table for example: update mytable set field1 = "OK" where field2 = "YES" but in my case, I want to update with key record number : 1st,2nd and 3rd record number showed in ACCESS mytable mytable in access that has 1 field1 only ...

Hi all, Is it possible to update with record number not with field name ? update mytable set field1 ="OK" where recno() = 1 ; I means here record number refering to index key 1,2,3,4 etc... index key 1 equal record 1 index key 2 equal record 2 TIA

Thanks Golom, You are right for 200509 not 200506, your codes worked fine but I also tried this simple way, it works too. Year(Now - 330) & IIf(Month(Now - 330) > 0 And Month(Now - 330) <= 9, "0" & Month(Now - 330), Month(Now - 330))

Hi all, I would like to get last 12 months date for example: 200609 to have 200506. ( year and month only ) I have tried this : year(now -360) & month(now - 12) gave me 2005-3 instead of 200506 Please assist or guide me. TIA

Hi all, I used a tool - database utility - database compact always gave me an error message : '''Invalid Argument ''' and then kick off Please assist to explain WHY this happened ? TIA

Hi all, I can not delete a table in *.mdb and gave an error message: Database Engine Microsoft Jet can not find an object '~TMPCLP410071'. Can someone got this error before and how to resolve this problem, please assist me ? TIA