Mail database

I am the Internal Affairs Officer at our local detention center and I am
responsible for the accountability of all incoming mail to our inmates. I was
wondering if anyone already has a database that I could massage for this
purpose. I only need it to accept the inmates name, OCA#, name and address of
sender, date received, general comment field. Any help would be appreciated.

I provide help with Access, Excel and Word applications. I would like to
offer to build your database for you for a nominal fee. Contact me if you
want my help.

Steve



"Need Incoming Mail Database" Need Incoming Mail
wrote in message
...
I am the Internal Affairs Officer at our local detention center and I am
responsible for the accountability of all incoming mail to our inmates. I
was
wondering if anyone already has a database that I could massage for this
purpose. I only need it to accept the inmates name, OCA#, name and address
of
sender, date received, general comment field. Any help would be
appreciated.

I figure you need two tables.
tblInmate --
InmateID - autonumber - primary key
OCA - text
Lname - text
Fname - text
Middle - text
Gender - text
DOB - DateTime

tblMail --
MailID - autonumber - primary key
InmateID - number long integer - foreign key
Lname - text
Fname - text
Middle - text
Suffix - JR, SR, II, III, etc.
Title - MR, MS, MRS, MISS, REV, etc.
Addr1
Addr2
City -
ST -
Country - default USA
DateRecd - DateTime
PostMark - DateTime
PostOffc - text - town, Zip, etc.
RMKS - Memo

Create one-to-many relationship between tblInmate and tblMail on InmateID.
Use form/subform (continous) for inmate/mail with Master/Child links set on
InmateID.

--
Build a little, test a little.


"Need Incoming Mail Database" wrote:

I am the Internal Affairs Officer at our local detention center and I am
responsible for the accountability of all incoming mail to our inmates. I was
wondering if anyone already has a database that I could massage for this
purpose. I only need it to accept the inmates name, OCA#, name and address of
sender, date received, general comment field. Any help would be appreciated.

"Steve" schreef in bericht ...
I provide help with Access, Excel and Word applications. I would like to offer to build your database for you for a nominal fee.
Contact me if you want my help.

Steve



From now on I am going to hunt each and every post of you Steve
Again.... It won't work but that 's no problem... it's a shame...

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!)

Arno R

"Steve" wrote in message
...
I provide help with Access, Excel and Word applications. I would like to
offer to build your database for you for a nominal fee. Contact me if you
want my help.

Steve



Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

"Steve" wrote in message
...
I provide help with Access, Excel and Word applications. I would like to
offer to build your database for you for a nominal fee. Contact me if you
want my help.



Paying *you* for your "services" of dubious quality is everyone's last act
of desperation.