access problem

[Cillies]

HELLO, I have been given the lovely task of repairing someone elses database, now the thing is that the DB was created in access 97 and converted up to access 2000, there was no problem here. but somewhere along the line one of the reports stoped working.

In my attempt to solve the problem I discovered that if I removed some of the entries the reports worked fine, I then discovered that Any company begining with the letters A-I did not work for example:

Andronics - did not work
TAndronics - worked

by just adding a new letter to the company there was no problem.

This has to be one of the most perculiar things I have ever seen a db do, if anyone has ever seen or heard of this type of thing before could you please let me know.
I would be very grateful for any assistance with this matter.

Kindest Regards
Cillies

 

[onpnt]

Is there a LIKE condition in the query that may be resulting in only values not starting with the A

When you converted to 2000 there may have been some changes to the query effecting the results. I've seen ( ) being moved and deleted and functions attempted to be inserted before, so the possiblities are endless.

can you post the query or even try seeking help on it in the Jet-SQL forum forum701

___________________________________________________________________

http://www.onpntwebdesigns.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page

 

[Cillies]

Thanks for the speedy reply, I managed to get it sorted, there was a calculation working in the background. But some of the data was missing from one of the forms. Once this information was entered the reports worked fine.

Kindest regards
Cillies