Adding 2 fields in a form Help

[winedott]

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

 

[missinglinq]

You simply use something like this for the Control Source of Field3, whether on the form or later in a report:

=[Field1] + [Field2]

 

[winedott]

Thanks for the quick reply. I figured out what I was doing wrong. I was placing the expression in the wrong place and not in the control source.

 

[missinglinq]

Glad you got it sorted out!