I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.
Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is

I have a table with a number of fields. I would like to allow the user to
perform a search on a field called Asset in table Asset Main, be prompted to
enter the text and have the result, if a match is found, display that field
and its corresponding other fields within that table ...

Ok guys fairly complicated one here...
I have a single table with 20,000 transactions within it. Each transaction
has a date attached to it.
I have another table which contains 3 fields, a StartDate, a FinishDate and

I'd like to change data column to row, it's the apposite way with cross tab
query. These are the sample of data:
Product       NY                  NJ             CT      
AAA            3                     5               4    

I have a requirement to select dates within a season. The seasons are linked
to different wildlife in the Db.   The season for different animals runs
from a specific date to a specific date which is the same every year.
How can I represent this in a query so that I can get back ...

Below is a simple query that returns all records with the same "Job Number"
SELECT Table1.[Job Number], Table1.SetterCompany, Table1.[Date To], Table1.
[Date From], Table1.Amount, Table1.[File Number], Table1.Text, Table1.Code
FROM Table1

I have a table of projects that includes cost.  A second table contains a
subset of projects that includes the project ID (matching the first table),
group and percentage to be multiplied by the project cost.  I would like a
query that returns all projects, providing multiple ...

I have a query called [AGECALC] that calculates the age of all entries in
table [MEMBERS].  It does this correctly using the common datediff formula
that everyone uses to calculate age.
I have a query [AGES BETWEEN] that searches for entries in query [AGECALC]

I am using a pass through query to copy data between a table located in a SQL
Server box local to the desktop running the Access application, and a remote
SQL Server box.  The copy goes both ways, first local to remote then remote
to local.  The local to remote only takes a ...

ORDER BY[Championship Competitors].Class,IsNumeric([Comp No])DESC,Val([Comp
No]),[Championship Competitors].[Comp No];
The above gives me a result of :-
class     Competiton number

Is it possible to define the jolly character '*' (star) as a query field's
criteria at run time? How?

SELECT *
FROM [TerritoryCoverage_finnleo]
UNION SELECT *
FROM [TerritoryCoverage_helo];

Hello,
I have done some looking but with no luck in regards to using miles in
access.  I have a table with all the zips in the US.  I will have another
table with a finite number of zips. I want to run a query that will provide

I have a report whose source is a query with criteria that is based on user
input - when the query is run ( or the report ), a message box pops up and
says "Enter partial description" - if a match is found in the specified field,
then the records are displayed - there is error ...

Here's my query:
SELECT TBL_RAW_IMPORT.EXCLUDE_FLAG
FROM TBL_RAW_IMPORT
WHERE (((TBL_RAW_IMPORT.EXCLUDE_FLAG)<>0));