Join two tables

[Guest]

I have created a somewhat basic forum which relies on two tables. Table A
which contains threads or topics if you so will and table B which contains
the replies to these topics. Table B inherits Table A's ID number as a
topicref.

Is there a way in which I can display all topics and all replies in a query
and order them by reply date and topic date. As an example I would like to
show the topic first and then I would like to show all replies associated
with that topic.

I have tried several solutions not really getting the desired result.

 

[Allen Browne]

In the Field row of the query, enter:
Format([TheDate], "mmm")
and specify this as the Column Heading.

The months will sort alphabetically, so you will want to set the Column
Headings property of the query (in the Properties box) to:
"Jan", "Feb", ...