I am very New to SQL and ACCESS so please be patient with me while providing answers
Hello I am trying to do this I have a database that checks for Burlary Alarms at Locations and then need the Citation Part to return specific values. I can get it to return when there are greater than 3 alarms but it returns all records even ones that should not be cited. :banghead:
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..
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 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.
I have attached the database as well
Hello I am trying to do this I have a database that checks for Burlary Alarms at Locations and then need the Citation Part to return specific values. I can get it to return when there are greater than 3 alarms but it returns all records even ones that should not be cited. :banghead:
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..
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 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.
I have attached the database as well