Search results for query: *

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

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

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

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

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

Hi all, What is the maximum of fields in Access 2000 o 2003 in one single table we can create ? because I have a text file with 1200 fields to be imported into Access table. TIA

Hi all, I have the codes in SAS below in the module or function called Macro_test.sas '----------------------------------------------------------- 'Parameter: Basetest=test , Scoring=test10 , month=9 %macro Macro_test(Basetest= ,Scoring= , MONTH= ); libname mydata &Basetest; libname mydata2...

Hi all, Is it possible to load a text flat file over 3 GB with SQLLoader into an oracle table ? I have tried with small flat file about 62 Kbytes which was worked fine but when try to load with 3 gb file the same structure, never worked. Please give some advice or ideas to result this...

Hi all, I have tried this example from Microsoft help to create cross tab query for multiple values but not lucky enough to get the results expected because it confused me a lot where I see to figure out this line : Field: Expr1: Year([OrderDate]) & " " & "Order Total"...

Hi all, I use this routine to export 2 queries to a single excel worksheet but always overwrite in the sheet1 with a second query below instead of having 2 sheets Public Sub export() DoCmd.OutputTo acOutputQuery, "qry - watchlistVP", acFormatXLS, "C:\temp\pme\pme_vb\watchlista.xls", 0...

Hi all, I run this query that works fine but I add one more IIF means more than 14 IIF gave an error : WHY SELECT...

Hi all, I have mytable that had 5 fields: dateyearmonth typename cause numLoss totalloss 200601 flex aaaaa 10 1000 200602 flex aaaaa 20 2000 200603 flex aaaaa 30 3000 200604 flex aaaaa 40 4000 to get a new crosstab queries table with these results in SQL statment if possible: 200601...

Hi all, I try to insert a string value date into a temptable ACCESS table but changed to unexpected value : WHY ? dim strdate as string dim strsql as string strdate = "2006-04-30" strsql = " INSERT INTO TEMPTABLE(VDATE) VALUES ("&strdate&")" docmd.runsql(strsql) but always gave me the...

Hi all, I am newbie to ADO to open an NorthWind.mdb such as employee table . Can someone help me with the syntax in VB to do this ? Sqlstr = ' select * from employee ' TIA

Hi all, I have a mytable with 2 fields: team score AAAA 10 AAAA 12 AAAA 14 AAAA 16 AAAA 18 AAAA 20 AAAA 22 BBBB 11 BBBB 22 BBBB 33 BBBB 44 BBBB 55 BBBB 66 CCCC 22 CCCC 77 CCCC 88 CCCC 99 DDDD 10 DDDD 12 to have in mynewtable AT LEAST the top 3 in each team if that team has more than 3...

Hi all, I have a mytable with 2 fields: team score AAAA 10 AAAA 12 AAAA 14 AAAA 16 AAAA 18 AAAA 20 AAAA 22 BBBB 11 BBBB 22 BBBB 33 BBBB 44 BBBB 55 BBBB 66 CCCC 22 CCCC 77 CCCC 88 CCCC 99 DDDD 10 DDDD 12 to have in mynewtable AT LEAST the top 3 in each team if that team has more than 3...

Hi all, I have a mytable with 3 fields: team amount option AAAA 1000 NO AAAA 2000 YES AAAA 3000 NO AAAA 4000 NO BBBB 1000 NO BBBB -2000 YES BBBB 3000 NO BBBB 4000 NO CCCC 1000 NO DDDD 2000 NO EEEE 8000 NO EEEE -700 YES in order to have data after DELETE team amount option AAAA 1000 NO...