The citation part of my database is the big quagmire lol

IN the Checking for Citations qry it pulls alarms greater than 3 as we cite on the 4th alarm. and generates a report this report shows all alarms previous and current and Should only be returning the listed group when there is a no for citation.

Example Freedom Toyota again has 4 alarms where they recived citations and 1 new alarm on 4/19/2014 where they did not recive a citation.. The qry pulls up all 5 so when they go to court the trooper can show the judge how many total alarms they had that were fault (which shows as #1) when they were cited previously and the new alarm to wich they are citing them for now.

PROBLEM: It is also pulling companies that have already been cited but show no new alarms that need to be cited on.. IE in the CITED column they all show yes instead of one of them showing NO.

Example: OUtten Chrysler Dodge and Jeep.. Shows 4 alarms with all of them being cited I do not need these on the report since they are not up for citation. They all Say yes

The basic premise on citation would be they need to have been sent a warning letter so that columb would say yes ( how ever on a new alarm the warning letter columb would also say no) and the cited columb would need to be a no.. If it is a No i need it to pull the previous yes's as well with the no as stated above.

If we get this to work right I will then move on to the update query but for me i think it will be better to do one thing at a time.

I am newer to access and really trying to learn the SQL so if you have an answer I would appreciate it. I have can email the database if you would like