I'm linking tables in a query and as I do so, the records are duplicated.  
What do I need to do to prevent this from happening?

I have a query with a field expression that checks that a begin_date is
greater/equal to 31/12/2006 and the end date is less than 01/01/2008.  The
criteria is TRUE.   It works perfectly.
What I want to do now is to take the year from a form. The expression that I

I'm attempting to study from home and got stuck on a question. I need to
create a query to calculate the average age of pets, grouped by the pet type
(i.e. dog, cat etc).
Just wondering if anyone can help me! It would be greatly appreciated!

Hi, please can you help me see the error?
This is my query qryChartTest
CountOfEmployeesName  PMonth   Total Hours  ContractualHrs   HrsToDo
OT40+  OT50+

i have a little problem. my tblServiceReports has 3 fields that i need to
manipulate.
the fields are ProductID, ServiceReportDate and SRDateDeleted
i also have a ServiceReportID field as the key for the table. each product

Table”invoice”
      Field  invoiceid   number
         “      invoicedate  date/time
         “     in quantity        number

I am trying to classify valid and non valid phone numbers using a
classification. Can I be told what is wrong with the third line?
Cheers
SELECT ClientID, Surname, DateOfBirth, Postcode, HomePhone,

I am a beginner with Access software. I have created a data base with
this software that is used to have information about the missions in
the office. This database has information about the name, cost, date
etc. In addition the data base is not in English.

I am trying to use a parameter search in my query to prompt the user to type
in parts of the field three times before the query will run.  I have the
following input into the criteria field.....
Like "*" & [Input Part of Dwg Title] & "*" And Like "*" & [Input Another

Is there a criteria I can enter in a query field that will return
records based on a selection from a combo box if it is made, or will
return all records if there is no selection made?
Thanks

I have a query based on three tables linked by a common identifier which is
meant to pull up monthly client market values based on the historical date I
enter in.  If I don't specify a date, it lists each discreet market value
based on the length of history of the client, so ...

Hi - Please help!!!!
I have created 3 queries to get to the point that I am at but still I
can't get it to work to my advantage.
qryTest

I need to get string right after "\".
For example if i have this path name
c:\Docs\Year\Months\June2007.txt
then i need get this string

I have a query that contains two tables:  One contains Case Numbers for one
group of clients (children), the other contains case numbers and service
dates for all clients. The query asks to match case numbers from both tables,
and displays case number and service date for only ...

Does anyone know if there is a way to display the table name as a field in a
query?
I have a UNION query that merges all of the records from 10 different
tables, but I need a field that indicates which table each record comes from.