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

"Bob" <x...@xx.xx> wrote in message news:f2lk0p$3pr$1...@lust.ihug.co.nz...

[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

"Bob" <x...@xx.xx> wrote in message news:f2lk5s$3qh$1...@lust.ihug.co.nz...

[Bob]

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

"JK" <nob...@home.now> wrote in message
news:OBryM$bmHHA...@TK2MSFTNGP03.phx.gbl...

[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" <x...@xx.xx> wrote in message news:f2m0gh$q6h$1...@lust.ihug.co.nz...

[Bob]

Thanks got it ASC...Bob

"Bob" <x...@xx.xx> wrote in message news:f2m0md$qkn$1...@lust.ihug.co.nz...

[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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Bob" <x...@xx.xx> wrote in message news:f2m3o2$vu3$1...@lust.ihug.co.nz...

[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" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:O2mjkEg...@TK2MSFTNGP05.phx.gbl...

[Douglas J. Steele]

Tom Wickerath

Entry 3 in the thread as displayed here:
http://groups.google.com/group/microsoft.public.access/browse_frm/thread/d5d2bde62df2ed82/3b1e865bc1787bc9?lnk=st&q=&rnum=1#3b1e865bc1787bc9

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Bob" <x...@xx.xx> wrote in message news:f2ns9h$7hb$1...@lust.ihug.co.nz...

[Bob]

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

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message

news:OdoIh%23nmHH...@TK2MSFTNGP06.phx.gbl...

[rjv...@ihug.co.nz]

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/community/en-us/default.mspx?dg=microsoft.public.access&mid=11bdab57-bf7b-4fe5-bf7e-19287900215e

____________________________________________

"Bob" <b...@the.races> wrote in message news:f2ob4b$30e$1...@lust.ihug.co.nz...

[Bob V]

Thanks Tom I see you now on msnews.microsoft.com...Bob
"Tom Wickerath" <aos168b at comcast dot net> wrote in message
news:nZKdnWlpTKR_JdLb...@comcast.com...