i want to establish a link between two tables in the same database (MS
ACCESS) so that if i update a record in one table it automatically
gets updated in the other.

I'm trying to design a database to track life insurance elections.  Employees
have the option of electing insurance for themselves, their spouse and or
children.
As far as table setup, here's what I was thinking:

I would like to edit a form and a report that currently are ordered by entry
date in chronological order to reverse chronological order so that the user
is seeing the last entry first.  Can you assist?  Thanks!

I'm looking to set up a tracking database that tracks holidays & sickness and
gives a report of how many for each employee so far at any point in the year.
Is this something that would be easy to set up or is there any examples
anywhere that i could use and modify??

I am trying to manage the holidays of the employees in access and I wondered
if there was an easy way to do it, like a multiple-selection calendar control
or something like that.
Anyone has any idea?

I have a form (with two sub forms) that users enter details of a new record
into. It all works fine except that I want the option to hit 'Cancel' and
have the users input discarded i.e. no new record created. However, when I
hit Cancel having entered some data in the fields a ...

I have switched over from Microsoft works database and simply want to sum
several fields in a record to a "total"  .  This was quite easy in works I
can not figure out how it is done in Access.
Thanks for your help.

Hey Guys,
I am really desperate to resolve this issue.  Below, you will detail
information about the problem.  I have the calculation working upto
calculating downtime even converting negative numbers to 0.  The

I calculated downtime using a query and now I need to change negative
numbers (not downtime) to zeros.
Please let me know how I can do that.
Thank you

I have not worked with Access for a while and am stumped.  I have a value
list for a field in a table.  When I develop a form off that table, the
entire value list shows and I only want the one I selected from the list to
show.  What step am I missing?

Hi,
I am trying to create a database in Access 2003 to get rid of my excel
spreadsheets and enhance reporting. I work for a non-profit and have to track
every penny in the inventory system with almost not margin for unaccounted

I need to be able to convert negative numbers ro zero in query.  How
do I do that?
Thank you

I searched through the database to find out how to do this, but
couldn't really find a satisfactory answer (then again, I'm not the
brightest bulb in the box! :-D)
We recently relocated a number of files on our central server, and now

I want some form fields to automatically populate with data once another
field on the form is filled in.  Specifically, I want a city and state to
fill in automatically once a zip code is entered.
My table tblZipCodes has 3 fields: fldZip, fldCity, and fldState

Hey Guys,
I created a form that have 2 check boxes, one for Pass and the other
for Fail.  I have both boxes unchecked, however I would like the user
to have to select one or the other before they go to next record.