I have a table that multiple users will use at the same time.  It basically
consists of a list of customers names.  I want to be able to select multiple
customers from that table when I am creating a new "project" so when I print
out the project report, the "customers" list on the ...

here is what i have got
SELECT "JAN" as Mth , id, quan, type
FROM tablejan
UNION ALL select "FEB", id, quan, type

Hello All.
I am attempting to create an Index in a table through a sql query, and I
keep getting a syntax error in create index statement message.
Here is what I have

Howdy Folks,
I have an involved request that is proving difficult for me, although I
have a few ideas. Here is my situation: I have a table (that resulted
from several previous queries) containing groundwater analytical

I am trying to set my null values to zero with the nz function in my query
for monthly sales totals, but I can not figure how to use it.  Here is my SQL,
can someone please help?
TRANSFORM Sum(qryCustomerSales2006.Amount) AS SumOfAmount

I've got a basic crosstab query set up that totals values by category over a
series of years.  The output looks like this:
           CAT1    CAT2    CAT3
2007            1            2           3

I got a monthly table
TABLEJAN
id     quantity     type
1          1            c

I have a query in Access 2003 and I want to only show the records from my
ThpyEndDtTm field that are the most recent.  I think I need to use the DLast
function and I have been trying to learn to use the builder tool since I
took a class and they were using this.  I was able to ...

I am compiling a query with fields from two different tables. Both tables
have a field called "PathLocator" and I need both of these in my query. There
is no difficulty in dragging these fields from the table boxes into different
columns in the query design.

i have the following formula
=IF(MONTH($B:$B)=MONTH(J1),+SUMIF($H:$H,"auto",$F:$F)+SUMIF($H:
$H,"auto",$E:$E))
problem is i am getting results (sum) of all of column F and E

I have a union Query linked to 4 select queries. The field names are the same
in each of the four queries. I'm trying to combine the four queries into 1
table showing the customer with their corresponding territory, region and
broker. all the tables are related by a customer ...

I am really not sure how I want to say this but I will do my best.
I have a query that is based off of a form with the following fields.
Employee ID, Last Name, First Name, Fulfillment
I want to add new fields in a Query and name them Certification Date and

What I'm trying to do should be simple, but I am not very familiar with the
access sintax.
I have a list control that gets its data through a query, I would like for
this query to retrieve records that are not older than two weeks. How should

<poster screams>
For some reason, when I run any UPDATE query, I get the box that asks me to
"Enter Parameter Value" for each of the parameters in the query.
Example query:

I have read everywhere that the maximum amount of columns that can be
returned in a query is 255. I need to be able to pull all the data from 2
tables so that I can display it on a form.
Is there any possible way to accomplish this without getting rid of any