i have a access table, service_calls, which has a filed named call_type.
the call_type filed will have a 1 or 2 character code for each record in the
table.
i am looking for help to create an update query which will allow me to

Hi, I am creating a search Query using SQL adapted from an online
resource.  While 'translating' the code to adapt to my Database I
received a syntax error notification while trying to run.  I have
searched through the parenthesis and cannot find the Error! Does

I have a MS Access database (from Office XP) to catalog my movies in.  Here's
my dilemma... I have Shrek 1 an 2.  From within Access, how can I query the
names so Shrek and Shrek 2 are both returned?  I either get one or nothing.
Here's what I have tried (among other things):

I need towrite a query to find out if there are any repet customers for a
specific month
ex if a specfic customer sends the same order twice for a month

I have a contact database which includes a field for category to
organize the contacts into correct groups for an email list.
The problem I am having is that when I try to sort or query to pull up
a specific category is that the people who belong to more than one

I am trying to restrict the data that different users can
see by capturing the login ID and using it as criteria in
a query, but I can't find anything on this topic. Can
anyone tell me if this is possible and how to do it?

Right now I have a form based on an autolookup query such that when I type in
my VendorID, it pulls out all the information automatically if the vendor
already exists. It also allows me to edit and save all the existing
information for that vendor which is perfect. However, in ...

This has probably been answered before
I have a query that when i run,  it returns exactly as i need if not linked
to anything (input form or report). The query is a parameter query that is
linked to a form (the form is a series of combo boxes). i have also

I'm working with a query and would like to know how to do the following:
If field [item] starts with the letter X or Z then field [label] would equal
"1" else "2"
This is what I have so far in my query but the syntax must be wrong:

I have a main table for new charges which havnt been billed which is
called tblNewcharges which has the following
ClaimID(pk)AutoNumber
PersonID

I'm pretty fluent in MySQL but I ran into a problem.  I have a database that
consists mainly of booleans.  It tracks whether people did certain things and
the layout is pretty simple.  However, I cannot figure out how to write a
query that will display the person's name and what ...

I'm pretty new to access so please bear with me.  This may be really
simple.  I have a table listing thousands of existing stores. In the
existing table i have a lot of geographic information including lat/
long, address, etc.  Periodically I will need to add new records from

I have the following field titled Path as part of a full query, that has the
following format of data, each row in the same format but different text.
/Community & Government/Social & Human Services/Individual & Family/Abuse/
Other rows in this field contain just

I have the following tables/fields relevant to the query I’m after:
Screened.site
Recruitment.DateOfReferral
all I want to do is design a query and subsequent report which shows the

I would like to create a cumulative sum for a percentage.
At the moment the data looks like this:
Turnaround    Count    Percentage  
3                     173         57.7