thanks
it works now....
Aditya jha
Last Activity: Aug 31 '11, 04:43 AM
Joined: Nov 30 '10
Location:
-
Suppose i have three columns : like below
Date Team_num ORS_ID
2/1/2011 12203 122013
2/1/2011 12203 122013
2/1/2011 12203 151013
3/1/2011 11203 156003
3/1/2011 11203 147003
3/1/2011 11203 156003
I need output in the following manner:
2/1/2011 12203 122013
2/1/2011 12203 151013
3/1/2011...Leave a comment:
-
i want to SELECT All from table but with date 2/1/2011 and UNique ORS_ID on a date. e.g. on 2/1/2011 there are three ORS_ID : 122013,122013,1 51013 out of which two is same and 1 is different, i need 122013 and 151013 as well as all column i.e. unique on a particular date...Leave a comment:
-
i need only in the below format
2/1/2011 12203 FEB 122013
2/1/2011 12203 FEB 151013
3/1/2011 11203 MAR 156003
3/1/2011 11203 MAR 147003
for 2/1/2011 there is two diff ors_ID 122013 & 151013
and 3/1/2011 there is also 2 diff ORS_ID 156003 & 147003Leave a comment:
-
I hve to show all column with a particular date with unique ORS_ID. Team numbers will be picked according to date and ORS_IDLeave a comment:
-
Select All column with Distinct on two column
Eg.
I need the output as :Code:[U][B]Date Team_num Month ORS_ID[/B][/U] 2/1/2011 12203 FEB 122013 2/1/2011 13203 FEB 122013 2/1/2011 12203 FEB 151013 3/1/2011 11203 MAR 156003 3/1/2011 11203 MAR 147003 3/1/2011 18903 MAR 156003
...Code:[U][B]Date Team_num Month ORS_ID[/B][/U] 2/1/2011 12203 FEB 122013 2/1/2011
-
Fetch data from DB2 using INNER JOIN with access file
Hi,
I want to fetch data from DB2 using INNER JOIN with access file, Is it possible. If yes then how?. -
Again my problem not solved yet,.
Qestion: I have one Listbox with two column 1 for Name and 2 for ID. I have one listview also which has to 3 column: 1 for Name 2 for ID and 3 for Text box data.
My Query Is that when I click on add button then it automatically add all items from Listbox to Listview with columnwise. But i want to do if the Name is already in the listview then it add only Text box data with same ID and name. No Name...Leave a comment:
-
search a listbox item
hi,
i hve three list box lst1, lst2 and lst3.
i hve 4 data in lst1, and 10 data in lst2.
My question is: if data from lst1 and lst2 data are same then it add data in lst3.( it means i hve to search all data from lst1 into lst2 and found data will be stored in lst3)
so please help me ..... -
Access Field auto assign TIME
Hi,
I have a Field name "Time" in a Table(Username) which save Current time. But if I try to enters blank time then it gives a error that it can not be null.
So i want to set auto insert current time if users will not give any time from manually. If users eneter manually then it take time in that table.
So help me.. -
Calculate sum in last row?
I want to export data from listview to an blank excel file then after exporting data in last row of that excel it will calculate total sum of that column.
My code is below for export data to excel but after this i can't create any logic , so please help me...
Dim XLAPP As Object
Dim XLWB As Object
Dim XLWS As Object
Dim icol As Integer
Set XLAPP = CreateObject("E xcel.Applicatio n")... -
I have textbox on form. I want to input only numbers(0-9) and (.) from user. and if user input except these then cursor can't go to next object. if Textbox is blank then Tab works to goto next object. So please help meLeave a comment:
-
My query is: suppose today is 30 nov, if I save date in database before 11:59 PM it will save as 30th Nov but after 11:59 it save as next date. My office timing is 04:00 PM to 04:00 AM. So tell me how can i save date in between these timing.Leave a comment:
-
Time and date Fixing
I have two field in database one for date and other for Time.I want to save data in 3rd field. My office timing is 04:00 PM to 03:00 AM. Suppose that today is 30th Nov, when i save data between 04:00 PM to 11:59 PM it will save in 30th nov but if i save after 12:00 am then it takes next date. My question is how can i save that data in same day i.e. 30 Nov.
No activity results to display
Leave a comment: