I have two table linked on the field 'Range' and the following query
returns 'Field' values in one table that aren't in the other.
SELECT DISTINCT tblderivative_11thNov07.Range
FROM tblderivative_11thNov07 LEFT JOIN tblSector ON

I have a basic query to add records to a table. A table in this query
contains numerous fields two of which are named "Criteria Field" and
"Criteria". I need to use the values from these fields as the field and
criteria in the query. In other words, lets assume the Criteria Field ...

I need help building an expression within a query or report.
I have 2 queries I am utilizing to create a new query.
The first query (Paid) houses this information:
    Month      Sum of Paid

I have a simple query which uses a function to return a numeric value
representing distance between to locations.  
The user is prompted to enter the Starting Latitude and Longitude
coordinates and the function compares those to a search table a returns the

I've searched the boards and am perplexed.  What is the best way to rank a
query that is ordered based on the descending value of a SumOf field?  Code
that fails appears below.
TIA

I am impoprting a text file into Access 2007 and trying to copy down data
from one field to the one below, unless there is data already present. If
data is present in the field below, then that data should be copied until a
new field with data is present.

Hi I am running the SQL query below in Access 2002/2003 without any issues,
but in Access 2007 it comes up with a 3139 Syntax error in the PARAMETER
clause.
Has anyone any idea what has changed in 2007?

Could someone explain the above message to me please.
This problem is happening in an Access database I created.  I copied over
the database and tried to recreate the error but can't.

I'm reading a transaction file of widgets delivered and I want to update the
quantity in the master record, so I do a query joining the master and
transaction data. That works fine.  I've also created a new element in the
resulting table, lets call it answer.  I want "answer" to ...

I have three tables:  tblVendors, tblForecast and tblTemp
tblTemp
VENDOR_NAME, SERVICESUITE_NAME, Q1, Q2, Q3, Q4, REGION_NAME
tblForecast

Hi all,
Im trying to write a query so that all data in all but two tables is
deleted, not the tables themselves only the data.
I keep getting these errors when im trying to build a suitable query..

Folks,
I've got a query that's something like :
SELECT Nz(Materials.MaterialCost, 0) FROM Materials
This works fine in Access but when I call from my .NET app, it

I have the following query that gets the most recent status:
SELECT tblProcesses.ProcessID, tblProcesses.AccountNumber, tblProcesses.
Process, tblProcesses.ProviderResponsible, tblProcesses.ProcessNote,
tblProcesses.DateOfProcess

This is probably a simple question to answer, but I'm only a dabbler
in Access so I'm not sure what to do.
I have a database of around 200 items. In one field are listed one or
more similar attributes (can be up to 50 or more) for each item. If I

I have a table setup like
[Hist ID],[First Name],[Last
Name],[Address1],[City],[Prov],[Country],[Postal Code],...
Thus I end up with data similar to