Recent content by winedott

I am wondering if there is a way to email a report that I have made and have access place the report in the body of the email instead of as an attachment. I have tried to send a report as an attachment but I am unable to figure this out. I have several other supervisors that have to send a daily...

I know the rules about saving calculations in a table, but I am in need of doing so for historical purposes unless anyone else has another idea that will work for my situation. I have read most of all the other post advising not to. I am building a DB that needs to calculate 2 fields and...

The best way to explain it would be first this DB is used 2 times a day (once for each shift). Each shift enters their end of shift numbers. This is going to be used a a jail setting. Ok here goes: 1) I need to store the total amount of inmates brought to jail for shifts 1 and 2. 2) I...

I have read several post that advise not to store calculations in a table. My calculations will not change. I need to pull a calculated field from the previous record. If I am unable to store the calculation from that record I am unable to get the correct count on the current record. My...

Well I answered my own question and figured it out. Thanks for your help.

Ok remember I am very new with Access. I reviewed that link and I have placed the following under Control Source under the field that I want the information to be placed. =DLookUp("[Value1]","tbl1","[IDData]=" & Forms![frm1]![IDData]-1) I am unsure what needs to be changed to pull the...

Hello again, Again I am very new to access. I am running access 2007. I am wondering if there is a way to pull data from a previous record and place it in the current record. For instance: Lets say that 10 customers called in for a service call. I was able to finish 6 of them. On the...

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.

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...