I am building a database for my kennel/training operation.  I have built a
form, tables, etc that show what I need.  
However, when I build a report I want to be able to show ALL the kennels
even if there's not a dog in them. (kennel space report) I have the columns

I have a geological database which needs to have 3D validation rules applied
to new data entries. Primary key is 'hole ID' for collar and geology tables.
I need to constrain geology hole depth entries to be always less than the
total hole depth as entered in the collar table.

How do I apply a picture from clip art/media(wmf.) to a document as a
watermark background? Please help.

I have a table similar to [StudentID] PK further down [ATSNo].  When first
assigned on a temp bases the [ATSNo] is the same as the [StudenID] field.  Is
their a way to may the default value of [ATSNo] equal to that of the
[StudentID].  Many thanks for taking the time to read this ...

I am designing a database using access and building tables for my classes.  I
have built a student table but dont know how to go about making my grading
tables.  There are 5 quizzes and a final exam, along with an overall course
grade.  The five quizzes use the same grading scale ...

Every time I filter my table, the report never automatically updates.  Is
there an automatic way to make the report update?

How do I set the non-primary index which uses multiple fields so that I
cannot enter duplicate values in the multi-field index?  I have tried
defining the multiple field index and then clicking YES on Uniqueness, but
this does not prevent duplicate entries in the table.

I just created an access database and now I need to put it online so that
employees can access it from anywhere.
Your assistance will be greatly appreciated.
Thank You.

About three weeks ago I had a problem with the Link Table Manager not showing
a new table I had added. A kind MVP gave a solution that worked, which was to
use the Link utility via the File > Get External Data > Link Tables. Now none
of the tables are shown in the Link Table ...

I am trying to establish a relationship between 2 tables. The primary keys
of table 1 are established on fields "Billing Account No" and "Billing Date"
. I have a field called "Billing Account No" in table 2 that is not a key
field. I tried to establish a relationship between these ...

I am looking for a simple issues management database which is similar to 2003
Access template offered by MS website.  I have Access 2002.

I have several tables that require many-to-many relationships; Would you
create one Junction Table holding the PK's of all the other tables.....or
would you make several Junction Tables?
What I am trying to determine is why you would have several Junction

Hi I would like to configure of the fields (the primary key ) to allow two
unique formats of entry.  These formats are:
1. A number which could range from 3 - 6 characters in length
2. Or a string in this format NUHT1234 (basically NUHT and four numbers)

Under Default Value on a date field, I want the current date to
automatically appear but I don't want the seconds because it affects my
reports.
I put mm/dd/yyyy under formats but that doesn't work.  Can someone help or