Hello everyone;
Here is a simple problem.  I want to find duplicates in a particular column
of a query (this query is joining together two tables).  So I've designed a
duplicates query to do the task.  I want to create a table alias (for the

I have a crosstab query where the Column heading is 'Wait: IIf([Clock Stops
in Period Flatfile]![Wait(Weeks)]<0,"0",IIf([Clock Stops in Period
Flatfile]![Wait(Weeks)]>52,"52+",CStr([Clock Stops in Period
Flatfile]![Wait(Weeks)])))'

I'm currently working on a script that will be executed when someone deletes
a "team" entry from a quality control database. The database contains teams,
employees and samples (each employee belongs to a team and for each employee
samples can be registered). Each sample has two ...

Good morning everyone!
My financial system's database (general ledger) keeps seperate tables for
each year. Each table (GL2007, GL2008 etc) has 14 fields:
* Account_number, Cost_account, January_balance,

I have made a basic query which is supposed to allow me to search for all
records in a table in a certain range, for example, May records, using the
syntax "Between [enter start date] And [enter end date]"  under the date
field criteria.  The query seems to work but always ...

I have made a command button in a form, that shows a rebort based on a query.
The query asks for a customerID. The customerID is shown in the form window.
How can i make the command button put the current customerID into the query?

I have a tree list control I want to populate with Categories based on a
Client.  The client number is input into a text box & then the update event
populates the tree based on the selection.  I get a syntax error when it
tries to open the recordset based on the SQL.  Two tables ...

I would like to create a text based parameter which will return the closest
match?
e.g Drink is the search citeria, the search will look for the word drink in
every record and bring up those with the closest match

I understand that when linking to an Excel spreadsheet, Access determines
from the 1st few records, what datatype to make the field. I have a date
field whose 1st 5 records are null. Access doesn't return any of the values
in that field. They are all null. How do I fix this?

I got an crosstab query that shows all stores based with how many items a
store bought based on a where artikel id = 'ddds'
If an store didnt bought any of the article it wont show up because of the
where clause. How kan I overcome this problem?

How to find Bigest date in a date field for a query.
As i use max() function in date field it give any error message:Cannot have
aggregate function in WHERE clause <clause>. (Error 3096)
Regards

Any suggestions would be greatly appreciated. This problem has been
bothering me for a week now.
I have a make table query which takes data from a linked Excel table and
creates a new 'Combine' table. When it creates the Combine table I also add

I am working in Access 2003 and trying to figure out a query from
my table that contains multiple Yes/No fields.
The user can select Yes or No for up to five shop names.  I am
trying to run one query with the following IIF statement  in the

This is my first time here and everyone appears helpful, so I'm hoping
someone will know the answer to my question.
I have a series of 12 Select queries that I am using in my Access 2002
database, that were created in Access 2000.  The idea of the queries is to

I'm sure I've done this in the past but can't figure how.
I have 2 tables "A" and "B" both with the following fields
Town; Council
I want to update Table "A"'s Council field with the Council