Sorting field in Detail section of report

  • Thread starter Thread starter stealth
  • Start date Start date
S

stealth

Hello everyone

I am constructing a library database and the subject keywords are
listed in the Detail section of my report.

The subject keyword is linked to a query of TitleID and SubjectID, this
in turn is linked to a table of TitleID, SubjectID and Subject Keyword.


I would like the subject keywords in the report to be sorted in
ascending order but everything I try doesn't seem to work.

My second query is that: that the subject keyword list is expanding.
As I add new keywords to the list, the list which is part of a subform
lookup table presents itself as is, I would like to have the list
sorted in the display but can't figure out who to do it.

all help appreciated.

:)
 
It is unclear from your message what you have in your database.

I would expect something like the following

TblKeywords
KeyID
KeyWord

TblSubject
SubjID
Subject

TblAuthor
AuthID
AuthFName
AuthLName


TblBook
BookID
BookTitle
AuthID
SubjID

TblBookKeywords
BKID
BookID
KeyID

(there will be other tables and fields of course,these are just a bare
minimum)

Is that the structure you have?
Evi
 
Sorting in Reports is controlled by the Report's Sorting and Grouping
Properties. With the Report open in Design View, click to select the
upper-left-most little square, right-click and choose Sorting and Grouping.

The sorting in the queries that supply data to reports is ignored, that is,
not used, by the Reports.

Could this be the problem you have been facing?

Larry Linson
Microsoft Access MVP
 
Thank you - I can't believe after trying so many different options t
sort the subject keywords that it was a matter of sorting the actua
report. I am truly still a beginner.

I will again post to the group for my second problem
 
Back
Top