I have two field as Long Integer.  Gas purchased and miles driven.
It calculates ok but rounds 10.5 gallons to 11.  How can I set it up so it
will calculate tenths of gallons and tenths of miles?
Thanks

when I enter a person using a form I want to enter their zip code and have
access automatically display the region in which the person lives.

Hi   I am running Access 2000 and want to create a drop down Calender that
will allow the user to select the date and enter into the field.
Is that possible and how is it done, I use Drop options for other data, but
cant seem to find any, on producing a date Calender.

We own a mortgage company and I will like to create a database of borrowers,
subject property, loan amount, date closed etc....  Can anyone of you experts
help me PLEASE

I have a design application question.  Does anyone have an idea on how to set
up an access application to keep track of gallons going in and out of a large
holding tank?  I would like to know the tank level at all times based on
gallons in and gallons out.    Also, is it possible ...

I need help designing a few tables as I'm stuck and just can't think outside
the box. Here's the details:
tblEmployees
- EmpID (PK)

I could swear I did this once many moons ago, but forgot how to do it - is
there a way to format just one tuple or one row different than the rest in
your table ?

Is there a good template for making a fire department activities attendance
database?
I have a membership sign in sheet and would like to track how many fires,
drills, meetings, and extra credit assignments they have attended for a query

Hi all.
I started this project with high hopes, but have arrived at a point where I
have built waaaaay too many tables, and can't make my reports do what I need
them to.

Database required for the above data

sI have created a report from a query.  The report has 3 field, i.e.
SKU;Product;QntyShipped.  In the footer I want to create a TOTAL for the
Quantities Shipped.  I have done this in the past but lost my report in an
upgrade.  I just don't seem to be able to get it right.  Help ...

This message is meant for someone in the Access Team at Microsoft.
I have made an application using Access 2007. When running the application
using 2007 Runtime on a machine which has Office 2003 installed, a
potentially BIG problem occurs.

I have a field that is set to date.  I understand =Date() will enter the date
when you open the form or table.  How do I get it to stay the original date
when the form is opened?  It keeps changing to the current date.

When in Table Design please add a way to alphabetize the fieldname list.  
It's very tedious to manually move the fields up /down one by one to sort the
fields in the table design.  I would like the fields to stay sorted when
viewed in table view.  Thank you.

I am working on database normalization and I have a theoretical question.
I have a table with 1000 records and two fields.  Let's call it tOrders. The
first field, OrderID is the primary key.  The second field, Location, can be
one of four options, TW, FF, EQ or SN.  Like so: