HELP! Querry is pulling incorrect information

[Nomi123]

I have a query that is pulling information from a database/table of employers and from a database/table of students and a couple of subforms.

Query has worked beautifully for 2 years but suddenly the query will pull all information but show only one company name for all data.

what has happened?

 

[John Big Booty]

Without seeing the DB. it's going to be very difficult to do anything other than speculate There could be any number of reason for this behaviour, chief amongst them; someone has changed the query structure/criteria.

 

[tehNellie]

The other less palatable alternative is that someone's managed to get an UPDATE query wrong and accidentally set all company names or references to the company table to point to the same company.

Check the contents of the table(s) as well as the query that now doesn't work.

As John says without more information to go on we can only really speculate.