I start a new table.
I have values such as 1.03, 1.01, 1.00 that I want to put in there.
No matter what foramt I set for the fields, when i type 1.03 in the
datasheet view it is displayed as 1.00.  Even if I set the format with

I am using the DSUM function, with query fields as inputs.  The inputs
are numbers.
When I use the DSUM function on them it returns values as text - not
numbers.

I have a combo box used to view specific customer records. I would like to
add <ALL> to my Search By Date combo box as the default value. Below is my
current SQL:
SELECT [Customer Query].CustomerID, [Customer Query].Expr1, [Customer

Using Access 2003.  I have a yes/no field on my table.  If patients are on
home meds it's yes if the meds are not home meds it's no.  I created a query
for a report.  On my report I want a field that only is visable if the
answer to the Home Meds field is yes and then I want it ...

I am looking to create a database of vendors that have a particular item.
I have an excel spreadsheet which has a list of stores carrying a certain
kind of dress and I also have a table already created in access showing a
list of all sotores in the region.  I want to create a ...

I'm creating a database for work, and I have NO EXPERIENCE with Access, other
than the file I'm creating now.  So please keep this in mind when answering
my simple question.
I need to create a list that allows multiple selections.  I have

      Is there anyway that I can open a query with the switchboard ?
I am trying to put a button on my switchboard that will instantly tell me of
all my suppliers in each county around the country...thanks in advance to
anyone who would like to help on this

How can I make my contacts list(in form view) display my contacts in
alphabetical order but without displaying blank records before I get to the
first "A" on my contacts list ....?

I have a select query to select records in a table. It returns the
correct data.
I want to append this data into another table. I can't figure out how
to do this :(

How do I create a form view of a table switchboard I have created ?

I have a DB which lists clients from a limited number of cities/towns (25 to
30 cities/towns) and would like to auto-fill the zip code (or at least offer
a second combo with a filtered list of zip code choices) .
This is my problem.  Some of the cities have several zip codes, and ...

Is it possible to open a query from the switchboard ?

I'm trying to learn how to use access for something for work.
I work with a lot of translators with vaying skills.
Currently I have an excel sheet with the
Translators Name

SOMEONE USED MY COMP AND WAS VIEWING PICTURES THAT I HAVE VIEWED EVEN
PICTURES OF ME I DONT KNOW HOW HE COULD HAVE VIEWED I SAW A WINDOWS MEDIA
SCREEN WHILE HE WAS VIEWING DID HE TRACK MY SITES I HAVE VIEWED?

I have a program that appends queries to a particular table. The problem I'm
having is that at times the append query doesn't always have all the fields
the table does and sometimes it does. How can I have a query that will apend
data on some of the table's field without causing ...