I have a table called TReport which have to
columns iTeam1 and iTeam2.
I have 3 teams, 1 2 and 3 where each of them have a name
which I get from the table TTeam.id

Hello I have a table with 3 fields. Field1 has an ID number. Field2 has a
code number and field3 has a value which is a number.
In this table the ID numbers of Field1 is entered more than once with
different values. for example:

I am trying to find the lowest value per row.  My data looks like this
Number    cost1     cost2    cost3   cost 4
152             50        25         30      20
200             15        20         18      25

Seems so simple - yet having all kinds of trouble.
I have a table with [Date], [Text1] and [Text2].
Raw data looks like this:
Date                            Text1        Text2

I have a data base that tracks employee absences (worth 1) and tardiness
(worth .5).  I am having trouble writing a query that sums the 'occurrences'
that are less than one year old.
Help!!??

I have a query that looks at check boxes in my database, it says the following:
WHERE [Aboriginal] = TRUE
UNION ALL
SELECT UniqueID, "Reintegration to High School" As Behaviour

I have used a union query to bring together 2 select queries, however I would
like to delete duplicates on the basis of 1 field only.  Is there a way of
specifying the criteria for dealing with duplicates?  I would also need to
tell it which query gets priority.

I have a table Ra that shows like that:
CSPC            Pieces
B1574            15,888
B1575            15,888

Probably a simple question, it's just been so long since I've worked in
Access.
I have a list of computers in Tbl_Computer. The KeyID for these is
PC_Asset_Num, which is a unique ID for each PC. I then have a list of staff

i have a record with multiple cities, i am trying to add a field and but all
the cities in one filed . What i have so far only repeats the city???
ID    Name                   City    All_cities
53    Bobby Brown    Atlanta    Atlanta Atlanta

I am trying to write a query which will spot duplicates. There are times
when the shipping department gets a duplicate sales receipt.  The data source
is a csv file that UPS Worldship creates for processing packages.  There is a
limitation to the data.  What it gives me is ...

I have a simple SELECT query which is based on two tables with an INNER
JOIN on the VehicleID field.
I noticed however, that if I added another table to the QBE grid - even
though I didn't link the table to my query's 2 source tables in any way,

I am pulling data from a listing of all 50 States. I would like to limit the
list to specifically hose States that I acually have customers.

Okay, the data I import is structure as so;
SERIAL#   ITEM NUMBER    WORK DATE
45612        P123456            12/7/06
45612        P123456            3/25/07

I have a database of runners times on each course. I also have the
year they ran that time and their age that year. I am trying to make a
top 10 list for each age and a top 10 list for all runners on a
particular course.