I am looking for a query that will show the last two occurences (by date).
The date are within a range of the year 2000 through 2006.
The issue I am coming accross is if the patient has an occurance in 2007, it
is counted as one of the two.

I am trying to setup a form which shows the clients info & only thier dogs
info.  My goal is to be able to us a drop down combo box that will bring up
each their dog's info.  
I am trying to set up a query for this (to insert into a form later)  I have

Hi,
i wanted to create a query that would run and like a parameter query you
have enter a criteria and then run the query, is there a way of creating a
query that provides you with a drop down box or list so that you can choose

Hi I am new to Access and I need help!  I am trying to create this query and
so far this is what I have:
SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan

i have a table tblFundAccruals w/ field names IndexNum, PID, Month, DueAmount.
.. these amounts will be accrued every month plus the unpaid amount in
arrears during the past years... my problem is when a certain PID goes to pay
an amount for example 500, how can i possibly allocate ...

Hi all. I'm new to access and trying to write a contacts database for
a college project.
A contact can have many disciplines, and each discipline can have many
subdisciplines.  This means the contact can have many subdisciplines.

All,
I need some advice on how to approach a complex query and update
problem.  I need to identify all records in a contract line items
table that are currently late to contract, then tag them as such for

I have a query linked to a subreport that may have null entries based on
which individual's data is pulled.  What I would like is to display the
subreport even if there are null values.  This is my query
SELECT IIf(IsNull([Support Date]),"None",[Support Date]) AS [Date],

I am getting an error when running a query with StDev in Access.  Most
rows have a good calc value, but 2 rows have an #Error value.  When I
try to sort by the StDev column I get an overflow error, I also get
overflow errors when I try to run a query based on this query.  The

Hi I got a table with 4 fields.There are some duplicate rows.I need to keep
one row and delete the rest.
Table is like this
feild1        field2      field3      fieLd4

I would like to populate with zeros where there are currrently blanks in
cells. I am using the folllowing SQL code and I am getting a Syntax error
missing operator message. Any sugguestions?
TRANSFORM Val(NZ(Sum([Qry_AIT_FSE _COGS_Summary].[SumOfMonthly Sales],0)) AS

I want to do an update query on a table I imported to change all records to
propercase. So far no problems.
In my table I have also a lot of greek names (in the greek alphabet) and when
I run the query all greek letters are replaced by questionmarks.

I want to do an update query on a table I imported to change all records to
propercase. In my table I have a lot of greek names (in the greek alphabet,
just the default font using the greek letter of that font) but when I run the
query all greek letters are replaced by questionmarks ...

I have created a Macro with 20+ "Select Queries". When the Macro is
run with the "OpenQuery" action, because these are "Select Queries" it
is opening all of them in several windows. I want to either :
1. Run these queries without opening a window

I'm trying to run   delete * from dbo_depend_table  and i'm getting
"single row update/delete affected more than one row" why?
I can understand if I had a where clause, but I dont.
system info: