I have a 'survey' database. I store the questions and responses in
separate tables.
tblResponses has the following fields:
ResponseID (PK)

I have a inventory table and a customers order table.Is it possible to
reduce the inventory table by the amount a customer orders? I set up a form
from these tables and of course, each time i enter a record , it just adds on
to the DB. I need the inventory to reflect an ongoing ...

I am new to access.
I am trying to prepare a database which will be used by my collegue to
montor supplier information.
There is a table for suppliers details.

I have a Crosstab Query where except the values, shows null values. Is it
possible to show the null values as 0 zero in the query or in the form and
in the report bases on the query ?
Thanks In advance

is there a wasy to set the default value for a field through code?
I have many tables - with lots and lots of fields - that were built without
assaigning a default value for the fields.
Since I would need to use SQL statement to populate may tables and since

My company provides an email marketing campaign that each time we run the
program, it increments several (but not all) fields in my database with a 1,
2, 3 or more.  I want to delete all records that are incremented after each
campaign is run.  I have been deleting the records ...

I've used Sql Server a lot, and need to use MS Access for a small project.
I am trying to use a single SQL statement to do a sub-select, like:
select * from (select * from Employees) as T1
I cannot use a nested Sub-query because that requires me to physically alter

Hello, I have 2 tables and try update T1
T1:                        T2:
   DD as Date           Emp as Byte
   Emp as Byte          DD_I as date

How do I add a page break to a text box?  I am usually a compiled database
and cannot create reports so I have to do everything in the query.

I have a table with projects (as a field), employee (as a field), months (as
a field), and manpower (as a field).  
From this table, I create a CrossTab Query to display the months across the
page with the employee downward.  This is to indicate the employee

"The expression you entered exceeds the 1,024-character limit for the query
design grid."
I just saved a make-table query with a new field name and evidently that new
field name is now too long or invalid, and I no longer can open the query or

What rules or logic define what numerals are given to cursor constants?
For example:
const adOpenStatic = 3
const adLockOptimistic = 3

Hi anyone
I would like help with the following:
I have a supplier form and a cmd button that opens a supplier order form. On
clicking this button, the form it is to open i want it to do the following

Hi could someone help on this. Here are the details.
I have a table with multiple columns. I want to creat a new column in the
same table and update that column depending on the values from the existing
column. For example if columnA (existing Column) has value of 0 or 999

I need help with this formula please
Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX