I have a Deposit Date which has many Deposit Receipt Numbers which have many
details such as PayeeName, Amount, AccountNumber.
I'm thinking I need a Table for the Deposit Date and a table for Deposit
Receipt Numbers and a Table for details.  There will be a O/M relationship

I'm using a form for a from/to date for users.  I was using the calendar
control but I ended up with some bizarre "froms" and "tos".  I set the "from"
to 1/20/2008 and got all the records from that date from 7:52 AM on....but I
was missing seven records from 12:27 AM to the ...

I have a database that I created that contains the following fields.
Date, Envelope Number, Name, Offering Type, & Amount.
Here's what I would like to be able to do?
I would like to enter the contributor's envelope number and have the

I have basic knowledge using access and im trying to help my school get some
kind of database set up for checking in and out books.  I need something
basic that will:
1) allow me to enter the books that we have in the library to keep track of

i am trying to delete a primary key however every time it tells me i cannot
until i delete the relationships.  when i go to the relationships and tell it
to delete all and click show all the relationships are still there.  is it
not possible to delete relationships or am i doing ...

All-
I have been stumbling through Access (I have 2000 & 2007 so I can work with
either one) trying to figure out how to accomplish the following with no luck
at all:

I have a large Access Database. When I want to print the reletions it shows
me just half of it, because it is too large for Ms Access.
Is there a way I can print them?
Thanks a lot!!

I'm designing a hotel reservation system for school and would like to add a
function to the database to remove hotel rooms from circulation based on a
yes/no check box in the table.
I currently have 3 entities the first being Guest which as the name states

Can someone help me with a formula?  I'm trying to arrive at the number of
years of service that reads 2.3 (two years 3 months).  My formula now only
gives me the years.  I would like the months included.  I would appreciate
any help someone could give me.

Can you suggest a way of setting up a data structure to meet my situation?
I have a table of students for whom I want to record a list of grades for
particular assessment points as they progress through the year.  A key
feature is that every student has the same set of assessment ...

I am building a database that has several tables, I have built a form that I
want the user to choose which table will be updated. Is it possible in Access
to have this option? Example:
Master table for a summary of time sheets for a year, then I have 26 pay

I need to be able to delete duplicate records in a table.  The problem is
that i would need to run this constantly.  I know about the procedure of
creating a new table with the duplicate records table and then using Append
query.  The problem with this is that I will always have ...

i would like to make a database that could hold information like a customers
name, address, phone, etc. then within the database either by button or thru
word, have it dump that information into a workorder or purchase order
template i've already made. and then after the workorder ...

I am working on a document retention db.  I originally set up an ole object
field to embed docs in the db.  I now realize since users are attaching adobe
acrobat files that this was pretty silly of me, since my db size doubled in
three days - (even w/ compacting)  Help!  What is ...

I am interested in building an Access application as a gift for my employer.
Essentially I am looking at Order Processing, Service Calls, & Product
inventory as the main functions.
The templates included with Acc2003 include databases for each.