Permanently Sort date field in ascending order

[lactbc]

Each record in my table has a date in the date field. I sorted the date field in ascending order but in my Report it doesn't seem to get reflected. The table is linked as a subreport in the Report itself, which in turn is also a Child linked to a Master table in the Report. To simply:

1st table is Patient with; Pat#,name,healthcenter,DOB
2nd table is Treatment with; Pat#,datetreat,drug1,drug2
3rd table is Laboratory with; Pat#,datelab,Labname,test

Tables 2 and 3 are linked to table 1 by Pat#

In my Report, the Master is table 1. I inserted table 2 and 3 as subreports.

I want the datetreat and datelab to be permanently sorted by ascending order, so when new dates gets entered, it gets sorted automatically by ascending order.

But when I print out my Reports, those fields are not sorted, even after I manually sorted them in the tables themselves. You know why that is? Thanks

 

[genomon]

In design view try clicking on the "sorting and grouping" button and assign the fields & sorts there.

 

[lactbc]

When I do that, it only gives me the option to select the fields from the master table1. I can't get into "sorting and grouping" when I highlight subreport table 2.

 

[dhookom]

You can sort and group in your subreport.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]