Mail database

[Need Incoming 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.

 

[Steve]

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
(e-mail address removed)


"Need Incoming Mail Database" <Need Incoming Mail
(e-mail address removed)> wrote in message
news:[email protected]...

 

[KARL DEWEY]

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.

 

[John... Visio MVP]

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
(e-mail address removed)

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

 

[Keith Wilby]

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.