I have created a joined column showing Customer Name & order number & Date in
order to create a unique identifier for each order.  There are instances of
multiple lines/orders for each customer and I want to be able to tell is this
identifier is found multiple time in my query.  ...

Hi, I want to have "000" in a text field as default if someone doesn't enter
a text or a number in that field. The field is a text field and allows only 3
characters in it. I would like for it to default to three zeros. I tried and
it only allows me to put on zero as a default. ...

I would like to build a select query that pulls all records and all fields
(about 8 fields) from a table where the records are unique in terms of id
code number field.  
Most records are unique in terms of their id code number field.  However,

I am trying to write a query that does a count of occurrances for each
day in a month starting on the first day of the month.  How do you set
the criteria to the first day of the current month through the current
date?  or the first day of the month though the last day of the month?

Help,
I have a card scanner that will create an Access database with the table
called Contacts, I need to append / insert this information into my database
table called tblContacts (tblContacts already has several hundred records)

Hi
Is it possible to have a nested IIF function in an Access query.  I can
handle the normal IIF([Stock]<10,"reorder now"," ") but was looking to
include more options.

I have a table:
idex  name codequestion       mark
1        A         MS_HR_RI1      40
2        A         MS_HR_RI2      20

I have a query that has the following fields and data:
EmplID, EmployeeName, Job Code, Cost Center, InPunchDate InPunchTime
OutPunchDate,
235689 Mouse, Micky        58 RN    102326          09/24/2006

I asked this question a bit earlier, but feel that I might need to be more
clear on my need.  
Here is an example of my goal.  Lets say we have a database of films.  Each
film has a related table of cast members.  What we want to do is be able to

When attempting to do an Automatically Delete Duplicated Entries Procedure on
a Contacts infomation table imported from Outlook, I get the following
message after trying to set the phone number as the auto key.
Microsoft Office Access

Alright, I have a table for each of my employees. We test for ten separate
second languages, and I have a field for each of these languages, containing
a lookup wizard to give a drop down menu of each possible test result. Now,
I'm trying to build a query that will give me a list ...

I have 3 shifts defined by the ID number of their foremen [Cast Forman
Clock].  Product 4620 can have several defects [Defect Code], of which "04"
is the one I am trying to analyze.  I have been able to calculate the
percentage of Defect-04 / the total number of pieces for the ...

For archiving purposes, I would like to make an automatic query that, when
ran, would make a new table with a particular field as the name of the table.
I'll elaborate:
Each time a new job is begun, there is table called "Job Information" in

I have three tables in my database with the following fields:
TbAo
- AoID (autonumber)
- StudyID

hi,
I would like to know the code to open a query in another database from my
database, and how to run part of a module in another database from my
database.