I have eg a list of 10 codes in 1 table.  I want a query to take the first
code and then look for occurences of it in another field in another table,
then move onto the second code and then the third.  The searches for each
code are to be wildcard searches since the code could be ...

I am trying to get the following query to work as a crosstab query, with the
dates as row header and the ID's as column headers and the PE's as the
values.  
Depending on the ID selected, the selected ID will have its PE shown, while

I posted this in the "General" section of the Access help form and realized I
probably should have posted it under "Queries".
I have a field called "backspan" which is a numerical value. I am wanting to
create a field called "cumulative distance". I want cumulative distance to be

Hi, All
I have a table with following fields:
IssDate  IssTime   Tick          Badge     Locat      Viol
6/18/07  15:30     102003      999        MAIN      141

I have the following query:
SO CA: IIf([All Programs Quoted crosstab].[State]="CA" And [All Programs
Quoted crosstab].[Zip_Code]<"94000" And ([All Programs Quoted
crosstab].[Broker_Name] Like "a*" Or [All Programs Quoted

In a query,m I have selected four fields plus the id field from a table of
50.
Each of the records are marked with an X or not.
ID    2000    2002       2004        2006    Count ?

*Access Beginner*
If I contain a set of numbers that are five digits in a column,
I.E. 02996, 03978, V3000, 02979
And I want to exlude every value that starts with 029 (by first 3 digits

I am trying to allocate a total I calculated using the sum function in
another query with all the records in another query.  When I try to bring
this single value into the query and calcuate off of it I get ambiguous join
errors.  I do not have a common value between the two ...

Ok, I am having problems formatting a date field to display a certain way.  
Here is how the data sits in the table:
PHONE CONTACT          6/10/06
EMAIL                          6/24/06

hopefully someone will be able to help me on this:
this is what my query looks like
last name     Direct    Training
Smith           $1000     $2000

hey all
I am not having any luck with this and am hoping someone already has
something build similar.
I have a unique ID field in the Super table and want to export this into the

I have two tables and one query. In table one there are too many values for
many employees. In table two”category table” there are 3 columns, one for
description of the category, one for “From” which contains % start from 0 and
in the last one is for “To” which contains % start ...

my intention is to build an application which would allow users to enter
data in a several local currencies and display/report data in  any selected  
currency
Example:

I have a database for employee ranking. And there are 3 tables, one for
employee personnel, one for annul performance, and the last one for employee
courses. In the annul performance table I need a query to select only the
last three years of performance and gives the average.

I have set up a Query in Access. In one of the criteria fields I have
something like this which ckecks each returned record's "state" field against
a value from a textbox. This is to see if the returned record is from the
same US state as the state selected by the user. (NY, CA, ...