Search results for query: *

Hi, I've a date column, p_date. I need to get the minimum of p_date. Like in oracle I was trying the min(p_date) but came to know it returns the minimum of numerical value. Can anyone pls let me know how to get the min of _date ? Thanks....

Wow.. got it... thanks much...

Hi, Help using awk or sed... I've a text file which contains pipe delimited data like, 100|EQTX|EQUITY TAXABLE| 102|GTHTX|GROWTH TAXABLE| 105|CPRESTX|CAPITAL PRESER TAXABLE - PFM| 103|GINCTX|GROWTH & INCOME TAXABLE| After using sed or awk, I need an output file which just contains the...

Hi, I've a delete statement inside my unix shell script, which will delete around 8 million rows. Is there anyway that I can do frequent commits rather than doing commit after 8 million rows. I've set the autocommit option ON and the statement is given below, delete from table1 a where...

Thx Martin... It mite have been simple for yu but for me as I'm totally new to Access I dont know these small things... Thank yu and yu deserve a star...

Answer 1: SELECT IIf(IsNumeric([dbarc].[acct_num]),IIf(Val([dbarc].[acct_num])>=680000,"70-","44-"),"44-") & [dbarc].[acct_num] AS cl_id, format(dbarc.ret_date-datepart("d",ret_date),'mm/dd/yyyy') AS post_date, 'M' AS post_type...

Hi Martin, HOw to export that query output to a new table ? You were saying abt append query ... how to use that ? What I did was I exported the query output to a .txt file and then imported that .txt file to a new table.... But all the decimal values was rounded... I dont want that to...

Have started a new thread... sorry abt that...

Hi, I've a query which creates an output with many columns. I want to transfer the whole query output to a new table.. The query output has some decimal values in the columns too which I want to have it the same...It should not get rounded... I just want to have the same values in the table...

Thanks Martin very much... it worked fine... I've one more question... I've a query which creates an output with many columns. I want to transfer the whole query output to a new table.. The query output has some decimal values too which I want to have it the same...It should not get rounded...

Error: Operation must use an updatable query While running the below query, I'm getting the error, Operation must use an updatable query. UPDATE CapgComp_init AS A SET A.cl_id = (SELECT LEFT(B.cl_id, 4)&T.future_state_account_num FROM CapgComp_init B INNER JOIN current_future_acct_num AS T...

Hi Leslie, Given below is the UPDATE query I'm trying.. but its giving "OPERATION MUST USE AN UPDATABLE QUERY" Can you pls let me know.. Thanks... UPDATE CapgComp_init A set A.cl_id = (SELECT LEFT(B.cl_id, 4)&T.future_state_account_num FROM CapgComp_init B INNER JOIN...

hi Leslie, back after a break... Actually its a query output which I want to update... That is I want to change the value of cl_id to the value of Col2 in Table2 with the beginning of the original cl_id if there are any matchings with cl_id from the query output to the Col1 of the...

OH no leslie... Its a Query not a table... So how we have to do now ? Should I create some temp table and populate it and then run this update ? Thanks..

Sorry.. again forgot to mention one more thing.. If it matches with Table2's column value, I need to get the value and put it in place of that existing value. Ex: 44-228100-674700 has a matching value in Table2 as Col1 Col2 --------------------- 228100-674700 674700C1...

Thanks Leslie.. the query works fine.. but my another question is, the cl_id is not a fixed length, it can be 13 or less than that.. for the below given values there is matching values in Table2.. so i need to get the matching values from Table2 for the below cl_id.... cl_id post_date...

Hi, I've an output from a query like given below. I've to again manipulate the result to get another output. I've to compare the values in the first field with a column in another table,Table2. But the question is, I've to compare from the 4th position of the cl_id. Ex: I should check this...

Thanks Duane. Yes ur a Access MVP and deserve a star. I didnt know that we can select from that existing query. Lot of things to learn. And thanks to Leslie too for ur input. -Nithink

I tried Datevalue too. The thing is I need to do formatting after I get the min date. Thats where I'm not able to do. Here's the whole sql which I'm using to create the extract(.txt). And it is the r_date field which is giving problem. Can you pls help me out in this ? Very much new to Access...

Duane, Its giving an error saying Syntax Error (missing operator) in query expression 'Top 1...' Actually the query I'm running has more than 20 fields in which one of the field is this date field which needs fomratting. Your second option of using ur first query as source for formatting...