If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting of data in a subform
Hi,
A colleague of mine has a contacts database and uses a subform to type any relevant comments about any communication with that contact with the date of that communication in a separate field. When there is more than one communication within any day it is entered as a separate record. In Access 2003, the subform records were sorted by date and then appeared to be in the order in which they were entered. Now, using 2007 (the database hasn't been converted yet), the subrecords appear in date order but not in conversation order. So, if 3 separate communications are entered for 12 October 2009, they are shown together as the form appears by date, but, they are then sorted alphabetically by what is typed in the communication comments field. Other than preceeding each comment with either a consecutive number or letter, or adding a date and time stamp field, is there another way to sort this out? My colleague is frustrated as it worked fine in Access 2003. Other than what I've mentioned I'm not sure how to help her. Any ideas would be gratefully received. Thanks very much. Karen |
#2
|
|||
|
|||
Sorting of data in a subform
On Tue, 20 Oct 2009 13:05:05 -0700, KarenF
wrote: Hi, A colleague of mine has a contacts database and uses a subform to type any relevant comments about any communication with that contact with the date of that communication in a separate field. When there is more than one communication within any day it is entered as a separate record. In Access 2003, the subform records were sorted by date and then appeared to be in the order in which they were entered. Now, using 2007 (the database hasn't been converted yet), the subrecords appear in date order but not in conversation order. So, if 3 separate communications are entered for 12 October 2009, they are shown together as the form appears by date, but, they are then sorted alphabetically by what is typed in the communication comments field. Other than preceeding each comment with either a consecutive number or letter, or adding a date and time stamp field, is there another way to sort this out? My colleague is frustrated as it worked fine in Access 2003. Other than what I've mentioned I'm not sure how to help her. Any ideas would be gratefully received. Thanks very much. Karen What's the Recordsource properety of the subform (post the SQL)? What's the DefaultValue property of the date field: if it's Date() then each record will get just the date, if it were Now() then it would get the date and time, which would sort correctly (but might cause other issues since the Date/Time field would contain both the date and the time). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Sorting of data in a subform
Why not use Now() for the default of communications date to get the sort but
set format of the form text box to short date to omit the time? -- Build a little, test a little. "KarenF" wrote: Hi, A colleague of mine has a contacts database and uses a subform to type any relevant comments about any communication with that contact with the date of that communication in a separate field. When there is more than one communication within any day it is entered as a separate record. In Access 2003, the subform records were sorted by date and then appeared to be in the order in which they were entered. Now, using 2007 (the database hasn't been converted yet), the subrecords appear in date order but not in conversation order. So, if 3 separate communications are entered for 12 October 2009, they are shown together as the form appears by date, but, they are then sorted alphabetically by what is typed in the communication comments field. Other than preceeding each comment with either a consecutive number or letter, or adding a date and time stamp field, is there another way to sort this out? My colleague is frustrated as it worked fine in Access 2003. Other than what I've mentioned I'm not sure how to help her. Any ideas would be gratefully received. Thanks very much. Karen |
Thread Tools | |
Display Modes | |
|
|