anyone know what code to use to find the modulus of a field?

I want to set a validation rule or "required" setting for
a date field in my table based on another field in the
same table.  Specifically I have a check box and want to
force the user to enter a date if the check box is yes -

I am builiding a database that has artists and customers and artowork sold
and mailing list tables.  Sometimes the artists are customers and buy
artwork.  I am going to give a primary key for the artists and one for the
customers.  But how do I get the customer-artists on the ...

Is it possible to have a field recieve calculated values from two other
fields?
I tried it with a form (which does the math) but it doesn't actually add the
data to the field.

Designed a database that lists all reports due to outside agencies for the
boss to use to track the report name, department and person responsible,
agency receiving report, frequency of report (annual, quarterly, monthly
etc), starting period (month name), ending period (month ...

We have an HR dbase with salary info.  Is it possible to allow access to the
dbase without seeing the salary field?  I don't think there's a way to
password protect a single field, is there?

I am getting a error on second line , is it that I have to change Me.Name to
something?
Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNewRecord

Hi, I am new to the world of databases, relational, flat, and any others.  I
have been at my part-time job for a year now, thrown into the world of an
existing Access d/b.  I now know that there's a lot of things wrong with this
d/b, and that I do not know enough to figure out ...

What is the expression used in acess to denote employees who started in 1999

I volunteered to help build a database to help the teachers at my
daughter's pre-school generate progress reports. It did not seem to be
a big deal at the time, but I am very stuck.
Requirements:  Generate a multi-page progress report for each student

Hello, I am trying to generate invoices from different forms (based on two
completely different sales tables). Does anyone else have any insight on how
to do this?
My problem is that while there are two distinctly different tables i am

I will like to design a database that would keep details of old and new
clients but also calculate automaticly if possible the period of time each
client has been with us i.e moved in on ---------- left on or current
date........

I am desiging a database that will host information about employees. The
problem is that there are about 5 different types of employees (hourly paid,
etc) and each of them have different information that is stored for them.
I am wondering whether to have a huge table to handle ...

I am requesting help with a DateDiff Calc.  I would like a query to return
only records that are over 45 days.  I have put >45 in the Criteria and keep
getting a Data Mismatch in expression error.
Can anyone help.

I am fairly new to this so I am not sure of the approach that I should take. I have a table that has approximately 30,000 records in it. Each record has an automated key field, 3 unique codes that refer to the product, a description for the product, a price for the product, an ...