I need some help on how to write a query that will look at a list of names
and addresses and mark the dups.  I want the query to look at the list if the
address1, address 2, city, state and zip are the same than mark it "dup".  If
not then leave blank or mark "No".   I am ...

How do i get the last date of a record in a qbe

Hello all. I have a query that breaks down comments I have made by company.
So let's say I have 10 comments per company. How do I make it to where only
the first comment of each company has all the information (such as state,
contact person, phone number, etc), and then the ...

Hi again I almost finished with a project but I need some help on how to
email diferent people with a table data here is my example
Log (This is the name of the Table)
the fields are

In a query, I have a table that contains 2003,04,05,06,07,08 enrollments for
all schools in the state. Also there are PROJECTED enrollments for 09, 10,
11, 12, 13.
I am trying to use Dmax or Max to get the highest of these 12 values so that

SELECT tPlayers.DateOfBirth, tPlayers.FullName, tPlayers.ClubID,
tPlayers.DateRegistered, tPlayers.Active
FROM tPlayers
WHERE (((tPlayers.DateOfBirth) In (SELECT [DateOfBirth]  FROM [tPlayers] As

I have several select queries all cascading to a point where i do a record
count.  these works fine.  i then have an append query that puts all the
record counts into a table, which also works fine.
the problem i have is that when 1 of the queries returns a null (or 0

I've read quite a few of the posts up here already and I seem to have a
mixture of problems and solutions, but none quite fit. So I 'm hoping
someone'll pick up and give me the light bulb on this one.
I have a query (qryOutputGrade), it calculates the standard deviated grade

Ok, I worked on this for 2 hours last night! I needs some assistance, any
would be greatly appriciated. I am new to Access and trying to work through
it to understand it.
The Problem: I need to Create a query that lists overdue items, the person

I have been trying to run a query to show the members who have used a
voucher. The field with this information is a "Yes/No" tick (check) box. When
I have run the query some of the members don't show up. Whenever I go into
their records to double check that the box is correctly ...

I am having trouble using an IIf statement as criteria. It seems simple
enough but does not work. I am using a Combo box to narrow down the condtion
of inventory. My combo box is simple: Good, Bad, All
HAVING

Not sure if this should be a union, but I have two tables.
Table A has DateOfEntry and Staff
Table B has Wage
I'm trying to get a grouped query where it will do grouping by staff but yet

I have two tables:
Table A:
Area   Date           Rate
1        4/5/2007      60.1

I am trying to use an Update query to replace the values in a table with the
result of a select query but I keep getting the message 'Operation must use
an updateable query'.
Are Update queries not allowed to use data from Select queries?

I have a link table where the field containing the parent key is named "PKEY".
In the parent table the key is named "KEY".
I wish to build a query to construct a recordset where the have the PKEY value
in a field named "KEY"