Hello,
I am a very new user to Acces. I am using Access 2007. I am a supervisor for a Sheriff's Department and attempting to create a database that will store a count sheet of inmates that are in a jail.
For instance:
Field1 [Females] This field is the total # of Females in jail
Field2 [Males] This field is the total # of Males in jail
Field3 [Total] Total of Field1 and field2
I have read several post and have seen that you should not store calculations in a table. I need this information to be pulled at a later date. I have to run daily, weekly, monthly, and yearly reports from this information. Currently I am using excel and creating a new tab for each day and it is extremly time consuming. I have my fingers crossed that someone out there can give me some guidence and help.
Thanks
Jason
I am a very new user to Acces. I am using Access 2007. I am a supervisor for a Sheriff's Department and attempting to create a database that will store a count sheet of inmates that are in a jail.
For instance:
Field1 [Females] This field is the total # of Females in jail
Field2 [Males] This field is the total # of Males in jail
Field3 [Total] Total of Field1 and field2
I have read several post and have seen that you should not store calculations in a table. I need this information to be pulled at a later date. I have to run daily, weekly, monthly, and yearly reports from this information. Currently I am using excel and creating a new tab for each day and it is extremly time consuming. I have my fingers crossed that someone out there can give me some guidence and help.
Thanks
Jason