For example:
SELECT Count(table1.[field1])
FROM table1;
But table1.[field1] is duplicated, how do I use word distinct, or other way

There are two table ,
Table1: name ,city ,salary,
Table2:city, province
Query1:SELECT table1.name,table1,city, Sum(table1.[salary]) as

I have a table of a few hundred thousand records that contains address fields
(AddressLine1, AddressLine2, AddressLine3) and in any one of these fields
could be a City, State Zip combination (the city, state zip is all in the
same field, not slpit apart and the zip might be like ...

I've got the following SQL but I'm am getting more results than I want
because of ties.
SELECT TOP 5 Warehouse, Count(OrderId) AS NumberOrders
FROM tWareHTrans

I have a table with dates.  I need to have it look down the table to the next
record and if its within five days add two dollar amounts together.

I have a database that records appraisal records for a group of people dating
back to 2001. Various details are registered including the appraisal date and
the year, the latter as 2001/2, 2002/3 etc. I want to extract the names of
those who did not have an appraisal in 2007/8, ...

I'm trying to concatenate records created by the same user for the same
customer on the same day at the same time (working with AS400 & each line on
a comment form is its own record). Here is what i have right now.
Comment: Concatenate("Select Trim([Comment]) from qryCommentsV2 ...

I am using a form to retrevie data from a query.  I followed the steps to
create a combo box on a form from
http://www.fontstuff.com/access/acctut08.htm. I want the user to be able to
select from a list of data.  Right now the form runs but the combo cox is

I have a query with fields showing below.
Mfr Model 1984 1985 1986 1987 1988 1989 ...........................2008
I need to sum the field from 1984 to 2003 and put that in one field. When I
tried this function (Sum[1984]+[1985]+...............+[1990], it is working,

Every time I open a saved word document, the following box pops up:
Opening this document will run the following SQL command:
Data from your database will be placed in the document.  
How do I remove this SQL demand.  It seems to be popping up an virtually all

I have 2 queries that generate 2 reports, both queries ask for "starting
date" and "ending date" these reports are always run together. Is there a
way where the date parameters can be passed to the second query, with out
asking for user input a second time?

I have this SQL
Delete * from table
where customernumber = 153
And now I need to delete more that 200 customers from my table.

I'm getting the following error when I run a query from an Access 2003
application using links to a SQL Server database.
The column prefix 'db.tbl_Gaps' does not match with a table name or alias
used in the query. (#107)

I have one table that contains city state and zip.  I have created another
table that has each of the unique values of above and another "code".  One of
the unique values is null, null, null, 4.  What I want to do is bring in that
value to a query that joins the above 2 and have ...

I want to create a query that searches for words in multiple columns. I
currently have it set up using Like "*" in the criteria for one column and it
works fine, but I want to have the user only have to enter a parameter value
once and have it return results from many columns. Is ...