Problem with sorting report

[lovett10]

Thanks for any help in advanced.

In a recent thread vbaInet helped me with the piece of code below

Reports!VisitSheetTableReport.OrderBy = "[QuoteNumber] ASC"
Reports!VisitSheetTableReport.OrderByOn = True

Whilst this works and in the report it says its being sorted in that way. it doesnt actually change from default (Date Of Work Descending) even when i tell it to go by Date Of Work Ascending

Im using Access 2010.

heres the full code (im using check boxes in a form for the user to decide how they want it to be sorted)

If chkDate = True Then
        Reports!VisitSheetTableReport.OrderBy = "[Date Of Work] ASC"
        Reports!VisitSheetTableReport.OrderByOn = True

Thanks in advanced for any help much appreciated

 

[vbaInet]

I wonder why you didn't continue the conversation in that thread?

How are you sure that it actually gets to that block of code?

 

[lovett10]

I wonder why you didn't continue the conversation in that thread?

How are you sure that it actually gets to that block of code?

Because in the report under the Filter/Sort section in shows the correct sort. But it doesnt actually sort it

 

[vbaInet]

I'm still wondering ...

I wonder why you didn't continue the conversation in that thread?

?

 

[lovett10]

I'm still wondering ...
?

I didnt know whether you or anyone would see it if i continued that thread

 

[vbaInet]

Of course we would. Any helper can see all the threads.

If you apply the sort manually in the OrderBy property and open the report, does it sort properly? Is the data type of the field a true Date/Time field?

Do you have any other sorting in place? Do you have a group by in place?

Do you have a sort in the query itself?

 

[lovett10]

Of course we would. Any helper can see all the threads.

If you apply the sort manually in the OrderBy property and open the report, does it sort properly? Is the data type of the field a true Date/Time field?

Do you have any other sorting in place? Do you have a group by in place?

Do you have a sort in the query itself?

no even if i do it manually it doesnt sort.

I dont think i have any other sorting in place, again dont think i have any grouping either

And i dont have an actuall query for the report just the sort/filter inside the report

 

[vbaInet]

Upload a sample db and I'll take a look.

 

[lovett10]

Upload a sample db and I'll take a look.

That wont work as all the tables of information comes from another database on the server

 

[vbaInet]

It won't take you forever to create a sample db in Access (i.e. one table - two or three fields, one query, one report), enter some sample data and upload it.