Solved Access report not sorted correctly (1 Viewer)

guillaumetel10

New member
Local time
Today, 12:02
Joined
May 20, 2020
Messages
3
Hi,
I use ODBC MySQL to access data from Access.
I have a report displaying different information, and I would like to sort it. So I use "Sorting And Grouping", it works except for certain fields. On the other hand, the same file works well on another PC.
Anyone know if this could be a version problem?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
13,327
Hi. Welcome to AWF!

Just a guess but check if the ODBC drivers are the same on both machines.
 

guillaumetel10

New member
Local time
Today, 12:02
Joined
May 20, 2020
Messages
3
Thank you for your quick response.
Yes, I tested several other versions, without result. The only difference I found is the Access version, unfortunately the sort works on the oldest.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:02
Joined
Aug 30, 2003
Messages
34,752
How does it not work exactly? Is it perhaps a numeric field that's sorting as text? If so, you could make sure to convert it to a numeric value in the underlying query.
 

guillaumetel10

New member
Local time
Today, 12:02
Joined
May 20, 2020
Messages
3
After several tests, apparently it came from the ODBC version. I took the higher version and it works.
It's a very strange bug. Thank you for helping me ^^.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
13,327
After several tests, apparently it came from the ODBC version. I took the higher version and it works.
It's a very strange bug. Thank you for helping me ^^.
Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
 

Users who are viewing this thread

Top Bottom