Recent content by ping99

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