I have a querry that contains few calculated fileds. Then ii would
like to add a row that would display one of my records if calculated
fields meet a certain condition. It doesn't work using the SQL view in
Access.

I checked help, the Internet, and this forum, but couldn't find an answer to
my question. We have a table that lists thousands of records for the year
2006. I want to build a query for a report grouped by quarters for the year
2006, using the [Date_Filed] field. I tried the ...

What am I doing wrong? Here is the SQL of the update query:
UPDATE tblTestUpdate INNER JOIN tblImportProducts ON
tblTestUpdate.MaterialNumber = tblImportProducts.MaterialNumber SET
tblImportProducts.Each = [tblTestUpdate].[Each]

I have a column of numbers ranging from -15 to +95 in a query.  In the next
column over I want to convert all numbers in the first column above 15 to 1,
all numbers above 0 but below 15 to 2 and all numbers below 0 to 3.  Please
help.  Thanks

I set up a parameter query where the user enters a date.  For some reason,
the "enter parameter value" box now comes up twice and the user needs to
enter the date twice before viewing the query results.  I looked at the query
in design view and nothing has changed on it.  Any ...

I have the following data in a query:
ID Cust     NAMECUS     SumOfBASE      Assests                    Lives
615            Cohn Real       5000                  
692            Gora               18                      19387

My problem is a two stage situation.
1) I was given a word document that has over 4,100 separate data items and
it was designed to be a merge document.  Will it be possible to use an Access
database to hold the data?

This is the SQL:
SELECT tjctPlanProc.PlanID, tblPlan.PlanNum, tblProcess.ProcName
FROM tblProcess
INNER JOIN (tblPlan INNER JOIN tjctPlanProc

I keep getting an error message saying "Invaid precision for decimal data
type" when I try to run the query I've included below.  How can I get this to
work?  
(I'm using the design grid, but I thought it might be easier to understand

I have a query that lists the results of a quiz. The key field here is
'Run_No'. This represents a group or session.
I want to to summarise the top 10 occurrences of 'Run_No' denoted by how
many times each Run_No occurs in the example table below.

Is it possible to do a max expression with a constant in a query? I have
tried to no avail. What I need to do is have it display the max of [Acreage
Price] or [200]. [Acreage Price] itself is a function of [Total # Acres]*.25.
I tried doing a huge expression with the hopes of ...

I have a database system here that is supposed to create certain Cost Codes
for every Job/Phase that is created. This is an automated process and
generally works great. Sometimes tho, It will not create the Cost Codes
needed and this causes errors later usually discovered when ...

I have an access database with 2 fields, one is a beginning balance the other
is adjustments.  The sum of beginning balance +/- adjustments is my ending
amount.
My problem is when there are no adjustments (ie the adjustment field that

I have a formula where =IF(D16>D15,"FAIL","PASS") but I need to add
that if d16 is blank then d19 needs to be blank and not put in Pass or
Fail.  Can someone help me.

How can I get the record number in a query that shows at the botton on the
navigation bar?  I have one table with 65 records.  I want to divide this
table in queries of 20 records only in alphabethical order(name field); if
query 1 is from A-F, then query 2, should conitnue from ...