 |  |  |  |  |  |  |  |
sort data in ms access querie
 |
•
•
Join Date: Jul 2008
Posts: 471
Reputation: 
Solved Threads: 24
Posting Pro in Training
I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like
name | address | date this 3 fields in table1
Roll | Class | date this 3 fields in table2
name | date | roll | date this 4 fields in querie1
now this data show in querie1 like
Taher | 17/11/2008 | 100 | 16/11/2008
but I want it show in two row with sort by date like:
Taher | 17/11/2008
100 | 16/11/2008
how can I do this
name | address | date this 3 fields in table1
Roll | Class | date this 3 fields in table2
name | date | roll | date this 4 fields in querie1
now this data show in querie1 like
Taher | 17/11/2008 | 100 | 16/11/2008
but I want it show in two row with sort by date like:
Taher | 17/11/2008
100 | 16/11/2008
how can I do this
•
•
Join Date: Jul 2008
Posts: 471
Reputation:
Solved Threads: 24
Posting Pro in Training
help me anybody please
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
use :
Select * From MyTable Order By MyDate
Regards
Veena
use :
Select * From MyTable Order By MyDate
Regards
Veena
you can also based on multiple fields one after another
.......order by field1,field2,field3.
.......order by field1,field2,field3.
Share your Knowledge.
•
•
Join Date: Jul 2008
Posts: 471
Reputation:
Solved Threads: 24
Posting Pro in Training
I delete all fields and make it new. now every thing is ok. but One problem. every data show double double. I mean same data show in 2 row.
•
•
Join Date: Jul 2008
Posts: 471
Reputation:
Solved Threads: 24
Posting Pro in Training
anybody help me please
•
•
Join Date: Jul 2008
Posts: 471
Reputation:
Solved Threads: 24
Posting Pro in Training
I attach a sample file. please check it. here same data (faruk)show in two row. another problem was it not show with sort by date.
MODIFY THE QUERY AS GIVEN BELOW
I have attached back ur file with the same change. plz have a look at it.
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
I have attached back ur file with the same change. plz have a look at it.
Regards
Shaik Akthar
Shaik Akthar
|
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Who has the database open?
- Next Thread: How to get mac address with input ip address
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
