I created a DB to monitor employee hours and i want to be
able to calculate how many hours an employee has left for
vacation.For example, 10 employee with each having 200
hours a year for vacation.How would the calculation work

I'm new here, so here goes my first question.
I'm making a table for tracking a type of form that I use.
The forms are numbered for tracking and I want to apply that number t
the table, the field is set to 'Autonumber' & is also the primary key

I can select multiple values in my form but those values
will not write back to the main table.
Help!
Thanks,

I'm new here, so here goes my first question.
I'm making a table for tracking a type of form that I use.
The forms are numbered for tracking and I want to apply that number t
the table, the field is set to 'Autonumber' & is also the primary key

Does anybody know what the different types of Databases
that you can design in Visio Pro are?  The list includes
types like Crowfoot, Bachman, IDEF1X, Object Role
Modeling, Chen ERD, Express-G, and Martin ERD.  I'm

I'm using Access XP
I'm seting up a date field, the data type is date already
I'd like formating and the input mask to use dd-mm-yyyy it doesn't see
to be a problem to use / but I want -

I made the quantum leap from "spreadsheet" to relational
database design.  One of the advantages I was encouraged
with was the ability to modify stuff without having to add
fields (like you must do when you spreadsheet).  I now

I created a table in either Sql Server or an MDB file with a recordId (key) and a set of integer type fields.  For example: recordId int (key), f1 int, f2 int, f3 int, f4 int
Then I tested data entry into this table by opening the table directly (through an Access project file for ...

Have a table with several fields.
Three of the fields are numeric int.
Let's say Field1, Field2, Field3.
Sometimes when I enter values in Field1,

I am quite new to designing databases and have a problem. It is a bit
tricky to explain...I would really appriciate help from anyone
experienced
here:)

when designing a new database, can I enter two tables with
similar names such at Contractor Code & Repair Contractor
Code that would carry the same info?  When I go to run a
report, would that botch it up?

Is there any way to delete a record from this table (the MSysCmdbars)? There
is a toolbar in there which somehow made it's way in there from an old
database and I would like to get rid of it.
Thanks in advance.

I'm going to split a database that is currently used by
approx 75 users. I understand that the FE needs to be on
the users hard drive. Question is: what is the best way to
distribute the FE? Do you re-distribute every time you

I'm building a database to track articles for a
newsletter. The articles deal with various court cases and
fall into one of four major categories. These four
categories are themselves sub-divided into from six to 19

I have a table that I delete all records from/then append records to on a daily basis. I modified the table by adding another field. My Append query now rejects a little over half the records due to validation rules violations. I've set no new rules. The new field is not required ...