I am trying to write a query that will allow me to find precincts that do not
share a location with any other Precinct. I have a table with two columns
Precinct and Sitenum. Each precinct is unique but it can be in a sitenum with
other precincts. I need to find and report parings ...

I have an Access 2003 database with a table that records each time a client
would sign into their account.  So there are multiple listings for each
client because it records the time stamp.  How do I build my query so it
would report on only the last date stamp for each client?

Hello! .... I'm in way over my head on this one but here's my problem:
basically, I've been asked to show (on a form or subform) results on a
Monthly, Quarterly and Year-to-Date basis. The table structure I currently
have is as follows (additional fields and/or tables can be ...

I am having a problem with trying to combine some data. Here is an example of
what I have now:
PMgr              ExpMW     ExpSE    ExpTotal     IncMW     IncSE     IncTotal
Smith, John   (114.86)   (430.32)  (545.18)    

I have a input table which I will need to separate by month, then eliminate
unwanted months.  I only want to work with the current month's data. Can I do
this without selecting and deleting each row. I would like to run a query for
this. New and confused

I need to use clause CASE in queries but I don't find information on how to...

how do I run a cross tab query but have it go into a make table?

I have a table with data like these two columns...
Name               State
John                 WA
I would like to use an Access query function or create a funtion i

I have created an index on 3 fields. It is a multi-field index and I'd like
to use it to access records in the database. However, I need help with the
query.
Is there a select statement that can be used?

Is if possible to have 2 or more sql statements with an access query? ie have
the first sql statement perform an update and them have another sql statement
perform a select.
Thanks

I thought I was nuts until I watched it happen:
I have a crosstab query that uses 3 fields for filtering.  One of them
is "TERRITORY" whose value is either "1" or "0".  When I modified the
query to remove either criteria (I wanted all records regardless of

Currently I have a database setup that bases information based on types
of cancer.  I have a single location in the database that has type(s) of
cancers a patient may have.  Originally I built up a query for each
type.  I now have a request that users get a dialog box so they can ...

Is there a way to store groups of queries in a folder.  If I have 50 queries,
it is hard to find certain ones even if I name them as specific as possible.
Thanks,
-A.J.

Why does Access tell me that: "Could not delete from specified tables"?
DELETE mattes.*
FROM KartObjektLista, mattes
WHERE mattes.ObjektID=KartObjektLista.ObjektID;

I saw some similar type questions posted -- I was able to make things work
using an append query, but it seems I should have a more efficient way to
solve my issue.  I have about 20 tables -- 4 of the fields together in each
table make a unique record.  A unique record in one ...