I have the round function set with 2 decimal places on a currenty field in
an Access table. This field calculates quantity x cost.  The cost of an item
could be below $1.00.  The quantity could be a whole number (1) or a part of
a whole (.5, 1.3).  I need to have the calculation ...

This is a logical question on my understanding of primary keys. If a primary
key is to uniquely identify records in a table and that same key can be used
to tie together various aspects of that same entity, why have two primary
keys?

On one of my forms I cannot add new records even though the allow additions,
etc., properties are all set to yes. The new record button is dimmed on my
toolbar as well. I can add new records in the datasheet and the two are
linked without referential integrity being inforced.

Hi,
I'd like to know how to set a validation rule for a field, so that the
values in it must be within a set which is defined in another table.
for example,

i have an item to sell, this item is broken up into different parts. I want
ot be able to use access to keep a record of these items and their break down
of parts and also calculate a price Can someone tell me if this is possible
with access

Is there any function to list table structure? Some type of report include
all the things that we designed in a table. I think there is a report in
Access 2003.But there isn't in Access Xp. If you know any other utility
software for this please write.

I'm trying to figure out the best design for a new database for a composite
primary key (CPK) where one of the fields may be a NULL - a violation of a
primary key. We will be using on SQL Server 2000 with an Access front end.
Existing database is entirely in Access and we are ...

I was asked if I could create a schedling db.  Mainly to spit out a report to
show who should work what days, what shift.  There's 6 employees, 3 different
shifts, 7 days a week.  Each emp gets two days off in a row and cannot work a
double shift.  I need to know how would it be ...

I created a database and related form for a survey. The survey has a number
of "open-ended" questions where people enter free-text responses. I
originally put all survey questions, including all the free-text, in one
table. When we tested it, I found that Access limits the record ...

How do I create a function to put in the initial time and date into the
specified fields in Access, I have the time() and date() functions but these
put the time and date of when the record is opened

I've been trying to figure out the syntax to stick in a Validation Rule for
a date field. The hardcoded dates work ( >= #01/01/2005# and <= #01/31/2005#
), but I need a floating 30 day buffer. Like ">= date and <= date+30".
I've been trying different ways for an hour now, and I ...

im trying to calculate the check diget for an isbn number, i know the theory
of doing this, i need to take each individual number and multiply it with a
weighting number.  my problem is, i'd like to put the isbn number in as a
whole field, ie 156054021, does anyone know how to ...

I would like to create a resource of recipies in order that I can use some
yes/no boxes or input boxes to say what ingredients I have in my cupboard and
follow the flow chart idea of ending up with a list of recipies which would
use up my ingredients.

I want to enter a date like 12/04.  The imput mask gives me everything but
this.  How do I set the Input for just a two digit month/year?
Thanks!

How do I create a function to put in the initial time and date into the
specified fields in Access, I have the time() and date() functions but these
put the time and date of when the record is opened