Access 2007 report does not work in 2010

[luppi13]

I have a report that I designed in Access 2007 and it worked fine. Now that we're using 2010, it is all messed up. The query gets the correct data, but the report does not display / print the correct data. Sometimes when I print the report for a specific student twice, I'll get different data on each.



Can anyone please help me?!!

Thanks,
Frustrated

[rpeare]

it sounds to me like your database doesn't know which record to choose when it's printing so you get inconsistent results. Is there any chance of you posting a sample database with enough data in it to get an idea of what you're doing.

[boblarson]

I agree with rpeare. Do you have a sort order set on the report? You need to do that or else you can get random results because you may not be aware of this, but Access does not store data in the tables in any specific order. It does not store it in the order the data was input to the table. So, if you expect it to come out in a certain order, you must apply a sort to it.

[luppi13]

I will work on getting a skeleton db for you. It has very sensitive information in it so I may have to make up enough data for it to do the same thing.

As for the sort/grouping... I am sorting it in the query and the grouping in the report. I tried to remove the sorting from the query but I got the same results as before. I'm just a little confused as to why it works in 2007 but not in 2010.

I'll work on getting the skeleton done and uploaded...

Thanks so much!
Sandra

[boblarson]

You can't sort in the query. Reports need to have the sorting applied in the Sorting and Grouping part of the Report. Query sorts are not adhered to by reports.

[luppi13]

I'll give it another try and see if it changes anything!

I'll let you know later tonight.
Sandra