Print order by Date

[Bob]

At the moment this code prints in order of the latest tblRemarks.dtDate, if
there is no date can the print order by tblRemarks.Category
(Asending)...Thanks for any help...Bob

SELECT tblRemarks.dtDate, funGetHorse(0,tblHorseInfo.HorseID,false) AS
HorseName1, tblRemarks.Category, tblRemarks.Remark FROM tblRemarks ,
tblHorseInfo,qryCategory where tblRemarks.HorseID=tblHorseInfo.HorseID and
qryCategory.HorseID = tblHorseInfo.HorseID and qryCategory.dtdate1 =
tblRemarks.dtDateORDER BY tblRemarks.dtDate DESC;

 

[Bob]

Oops sorry here is the Private Sub
Private Sub Report_Open(Cancel As Integer)
Category.ControlSource = "='" & Form_frmMain.cbCategory & "'"
Me.RecordSource = "SELECT tblRemarks.dtDate, funGetHorse(0,
qryCategory.HorseID,false) AS HorseName1, " _
& " tblRemarks.Category, tblRemarks.Remark FROM tblRemarks, qryCategory
WHERE qryCategory.HorseID " _
& " = tblRemarks.HorseID And qryCategory.RemarkID1 = tblRemarks.RemarkID
" _
& " and tblRemarks.Category='" & Form_frmMain.cbCategory & "'" _
& " ORDER BY tblRemarks.dtDate DESC; "
Debug.Print Me.RecordSource
End Sub

Thanks Bob

 

[Tom Wickerath]

Hi Bob,

You need to use View > Sorting and Grouping within report design view to
specify sorts. Reports will not honor sort orders specified in the
recordsource.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[JK]

Bob,

ORDER BY tblRemarks.dtDate DESC, tblRemarks.Category;

Regards
Jacob

| Oops sorry here is the Private Sub
| Private Sub Report_Open(Cancel As Integer)
| Category.ControlSource = "='" & Form_frmMain.cbCategory & "'"
| Me.RecordSource = "SELECT tblRemarks.dtDate, funGetHorse(0,
| qryCategory.HorseID,false) AS HorseName1, " _
| & " tblRemarks.Category, tblRemarks.Remark FROM tblRemarks, qryCategory
| WHERE qryCategory.HorseID " _
| & " = tblRemarks.HorseID And qryCategory.RemarkID1 =
tblRemarks.RemarkID
| " _
| & " and tblRemarks.Category='" & Form_frmMain.cbCategory & "'" _
| & " ORDER BY tblRemarks.dtDate DESC; "
| Debug.Print Me.RecordSource
| End Sub
|
| Thanks Bob
|
| >
| > At the moment this code prints in order of the latest tblRemarks.dtDate,
| > if there is no date can the print order by tblRemarks.Category
| > (Asending)...Thanks for any help...Bob
| >
| > SELECT tblRemarks.dtDate, funGetHorse(0,tblHorseInfo.HorseID,false) AS
| > HorseName1, tblRemarks.Category, tblRemarks.Remark FROM tblRemarks ,
| > tblHorseInfo,qryCategory where tblRemarks.HorseID=tblHorseInfo.HorseID
and
| > qryCategory.HorseID = tblHorseInfo.HorseID and qryCategory.dtdate1 =
| > tblRemarks.dtDateORDER BY tblRemarks.dtDate DESC;
| >
|
|

 

[Bob]

Thanks Jacob, and then Remark field next to ascending
ORDER BY tblRemarks.dtDate DESC, tblRemarks.Category; tblRemarks.Remark
ASCENDING ???
Regards Bob

 

[Bob]

Got it but dont know the short cut to Ascending for Remark
& " ORDER BY tblRemarks.dtDate DESC,tblRemarks.Remark DESC,
tblRemarks.Category ;"
Thanks Bob

 

[Bob]

Thanks got it ASC...Bob

Got it but dont know the short cut to Ascending for Remark
& " ORDER BY tblRemarks.dtDate DESC,tblRemarks.Remark DESC,
tblRemarks.Category ;"
Thanks Bob

 

[Douglas J. Steele]

Did you not read what Tom posted? It doesn't matter what ORDER BY clause you
have on the query when dealing with a report. You MUST use the Sorting and
Grouping feature of the report.

(And, for what it's worth, Ascending is the default, so it's not really
necessary to include the ASC in a query)

 

[Bob]

Douglas, Tom Who, I can not see a posting on this tread from Tom!
and I can assure you that the 2nd list being Remarks was not in any
alphabetical , Thanks Bob

 

[Douglas J. Steele]

Tom Wickerath

Entry 3 in the thread as displayed here:
http://groups.google.com/group/micr...65bc1787bc9?lnk=st&q=&rnum=1#3b1e865bc1787bc9

 

[Bob]

Sorry Douglas I am using Microsoft Outlook Express and not showing here,
thanks Bob

 

[rjvance]

Ok sorry Now I can see it through Google....Bob

 

[Tom Wickerath]

Hi Bob,

You might want to try switching your newsgroup server to news.microsoft.com.
My contribution to your thread is showing up on that server.



Tom Wickerath

PS:

This message posted using the news server "newsgroups.comcast.net", just in
case you are not seeing any messages posted to news.microsoft.com. Also,
here is a link to your thread using the Microsoft "web portal":

http://www.microsoft.com/office/com...cess&mid=11bdab57-bf7b-4fe5-bf7e-19287900215e

____________________________________________


Sorry Douglas I am using Microsoft Outlook Express and not showing here,
thanks Bob

 

[Bob V]

Thanks Tom I see you now on msnews.microsoft.com...Bob