Member Avatar for karanvs

Hello,

I have a problem with sorting record in my access 2000.

I have created a query (name - BOP Month wise) which has a date field where records are grouped month wise. When i first create the query, it shows correct figure i.e. records are grouped and properly sorted month and year wise. But when I close it and re-open it, the sort order always changed and sorting becomes alphabatically (based on date field). I have also created a report based on that query where grouping and sorting has been done but the problem persist.

Please help me to sort out this problem. I am a very new to MS access and this is my first project where i have put a lot of hard work.

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Sulley's Boo
Member Avatar for Sulley's Boo

Can you show us your query, please?

This should not happen if you have the order by clause in your query .. :?:

commented: U know hindi! cool ! :P +2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.