Search results

i am really new to queries.. and this might seem very easy to u all.. but please lemme know.. i have a huge table and i have to change some values.. how to do it in one go... thnx piyush

thanx.. a lot

i have some query which i run every day and want to keep a record of different data it returns. for this i import that query as table. but each time a new table is formed.. is there any way i can directly pull the data returned by this query into an already existing table.

"this_mnth" "that_mnth"

yes.. i want that

can i rename columns of a crosstab query?? can u explain using this example.. TRANSFORM Sum(foJUN.OPEN_INT) AS SumOfOPEN_INT SELECT foJUN.SYMBOL FROM foJUN WHERE (((foJUN.STRIKE_PR)=0) AND ((foJUN.OPTION_TYP)="XX") AND ((foJUN.TIMESTAMP)=Date()-1) AND ((foJUN.INSTRUMENT)="FUTSTK")) GROUP BY...

am new to sql please tell me where to put it in my sql query. thanx piyush

SELECT FO.SYMBOL, FO.today, FO.yest, (today-yest)/yest*100) AS perc FROM FO WHERE (((FO.today) Not In (0)) AND ((FO.yest) Not In (0))); sometimes when the value of FOValInLakh.[6/18/2008] is 0 i get #error. I am not able to sort(MAIN REQUIRMENT). if i use not in (0) criteria... i loose out...

thank you khawar.. i just have basic knowledge of SQL it would be great if you can explain me this part of ur query,, [DateS] & "-Qty"

dude i am using an older version of access.. so could not see what u have sent... plz help

SELECT June.Scrip, Avg(June.[Quantity Traded]) AS [AVG] FROM June WHERE (((June.[Trade Date])>Date()-14)) GROUP BY June.Scrip; the above query gives me average of Quantity traded for last 14 days... now i want to see today's(or yesterday's) quantity traded as % of this average.. how...

crosstab works only when i have 3 fields.. lemme re-state the problem i have a table which contains 5 feilds: scrip, date, qty, deliverable qty, deliverable qty% there is no primary key defined each day i recieve values for qty, deliverable qty, deliverable qty% for some 250 scrips(varies rom...

i m using an older version of MS Access so cannot open ur file :( plz send me the sql.. and design details... i guess i will be able to understand

crosstab allows me to select only one field.. i need to show multiple fields

i won't be using any real time data.. this is just for reporting purpose.. plz help

i am really new to access i have built a table which appears like this: SCRIP DATE QTY A 6-jun 100 B 6-jun 50 . .. .. Z 6-jun 200 A 5-jun 140 B...

there is a set of data (some 15 fields) related to some 250 co.s which NSE releases everyday. this data is contained in 3 different tables which is made available at the end of each working day. i need to make a database from this. how can i incorporate all these data in three different table...

hi, i want to import data from an excel file starting from the 5th row. how can i do so efficiently.

thanx a lot both of u..

hii i am new to access.. was trying to make a primary key usinmg 2 feilds.. its showing a problem that null isnt allowed.. i compacted the file.. even then its not working plz help