I have a field called Quantity...
If Quantity =1 and I divide by 2 I get 0
How do I get it to eual .5
Thanks

I have a table which contains all the fileds in the database.
I have a form which is used for data entry.
On this form I have fields (which exist in the original Table) where
calculations and their results are correctly displayed.

I have about a month of experience with Access and zero VBA.
Building a candidate tracking database for HR department. Need help with the
following questions. Can Macros be built to do these functions?
1. Send an Email directly from Access?

I currently have a sub-form with a autonumber field.  However if I go back to
a record and modify the data, autonumber recreates a new number.  This causes
a problem as there are a few fields that do not allow duplicates, hence an
error occurs.  

I have a created a form with 4 tabs so I could get all my controls in one
form. However, when I was entering information into my form, I wasn't able to
go to the following record, it just stayed in the first record. What can I do
to in order to enter information in my form and go ...

I am new to access and need someone to help me set up a new table i guess you
would call it. I am us to using excell and I us worksheets there. I am
needing to set it up so i can get this information.
date/time

I have about a month of experience with Access and zero VBA.
Building a candidate tracking database for HR department. Need help with the
following questions. Can Macros be built to do these functions?
1. Send an Email directly from Access?

I’m dealing with this doubt for quite sometime. It all begins with table
design. I’m putting this here to see if someone can just point me out in the
right direction because I already build my DB from scratch a zillion times
now.

Hi, I have a form for user data entry set up. I have a save button as the
last tab. However, as long as the user tabs through and fills in all the
Required fields, the record gets saved without having to click on the SAVE
button. Is there any way to prevent a record from saving ...

(I am new to the job) We have approx. 7-10 databases that need to be in one
location for more efficiency.  I need advice on this.  First i think that i
would create a new group then link tables from the original location and then
import the other reports, etc.  Is this an ...

One of the annoyances with a couple of dbs we have is that once we open the
form, we always need to click into the first field.  Is there a way to get
A2K to navigate to right starting point when user opens a form so that once
it's open, we're ready to go?  Otherwise, pain in the ...

I want to start numbering my document ,excluding the title page and the table
of contents.

2 problems:
1. I have an Address table that has a one to many relationship with a Names
table (so multiple names have the same address)  They are connected by the
primary address id key.

To All,
I am looking for some help regarding the formatting of a text field on
a report. Here are the details:
I have a table named "tblMastPref" without the quotes, in that table

I'm using a query to calculate the totalt value of some orders.
How to display ALL orders in the answer. Not only orders with a saldo. I
want the orders without saldo to get saldo = 0.
I want everything to be done in the same query.