I can not seem to make the following query updatable. Please help:
SQL view:
SELECT Projects.*, Projects.[Year of Project], [Business Units].[Sort
Order], Projects.[Project name]

               I have a query which has the following fields:
ROOMS
RESNAME
ARRIVAL

I appologies if this is a repertition of questions posted before.  I
have been searching all day, I believe I have found some solutions but
they seem to be a little out of my league in terms of interpretation.
Here goes....

I need help with the following. I'm not a programmer, but need to fix
one thing. Can soeone tell me what's wrong with the following?
"SELECT * FROM TblEvents WHERE DATEDIFF('d', fldDateArchive, now()) <
0 & DATEDIFF('d', fldDatePublish, now()) > 0  ORDER BY fldDateEvent

ozip   dzip    shipdate       wgt         Transport cost
A       B          12/1/07    20000         450
C       D          4/1/08      15000         890
E       F          9/1/08       18000         750

I'm trying to build a query which asks for one parameter "SEARCH TERM", and
locates records from one table, where the string "SEARCH TERM" is found
anywhere within any of three fields.
ie. Product List - Has Product Code, Name and Description fields.

Is there a way to set a variable/criteria in a pass through query?

I have a database consisting of several tables that contain information on
patients. Each unique patient has information linked across tables by their
ID number.
I have a query that returns two columns of numerical data (call them A and

need some help with the following select stmt:
SELECT CIEmpDir.EmailAddress, CIEmpDir.WireTransferLimitCust
FROM CIEmpDir
WHERE (( (Mid(([CIEmpDir].[EmailAddress]), 1, (InStr(1, ([CIEmpDir].

I am working in access 2007 and have a goal amount that i need to calculate a
10% increase.. I cant figure out how to do this!!

Is there an equivalent of vertical bars (see example below) to refer
to records with ampersands ("&") within them?
http://www.jlcomp.demon.co.uk/faq/litampersand.html
Thanks,

I have a qry to sum the planneddate field in my maintbl and groups it by
month. I  need the sum of those grouped totals in a cumulative format. See my
sql from the qry and please help me get this column to be cumulative
SELECT Format([planneddate],"mmm") AS PlannedlCumulativeMonth ...

I download a list of information onto a table, and i'd like to make a
search on that item. I put in     "*" & [Search Item] & "*" into the
item field with the wildcards just in case. This works fine. Now lets
say I'm looking up cars, so in the search input box that pops run when

I know this is a basic question and I looked in the help file but can't get
the function to work ...
I have a 6 character numeric field but I want the query to return only the 5
right characters.  For example:

I am attempting to write a simple query and when I choose the information in
ascending order I am receiving an error message that states a record has been
deleted and will not provide the report. I'm finding that I'm receiving this
message on several already created queries. How ...