I have a problem here that I can't figured out a solution.
I have a query this this fields and values:
ProdctionNo           Production          Value1          Value2          
Value3         Value4

Is there any way in Access (2003) to edit a query's SQL statement
without first going into design view?
Some linked tables on our main database have inherited more than the
maximum number of indexes that Access can support, and as a result

Can someone help me out with how to enter the correct expression in a field
of a query? I want the calculated field to return "N/A" if the result of a
formula is an error. The formula is
=DCount("[UM]![13]","UM","[UM]![13]='Y'")/(DCount("

It is possible to run a query to inser a blan row in my table?
If yes, can you please let me know how can I riight SQL?
Your help is great appreciated,

Ineed to create a Make Table quey that will apply an auto numbertha resets
with a change of value in a speciffic field.  The end result would be to
create a cross tab with the AutoNumber values as the column heading.
For example I have a database of circuits that feed customers.  ...

I would like my parameter query to bring back records by the end user typing
the first three letters of a description. There should also be the option of
leaving the parameter blank to return all records. Can this be done?

Is it possible to use parameters in the select line e.g.
PARAMETERS Param1 Text ( 255 );
SELECT [Param1] AS Expr1
FROM Customers

I have a query that has a syntax error.  The pop-up error window takes focus
and one cannot use the design view window to make the needed correction.  If
one closes the error window, the design view window also closes.  One cannot
access the SQL view to make the needed changes ...

Is it possible to create an expression based on a parameter query?

I have eight text boxes from which I filter data on records on a form.  I
want to make a table using a Make Table Query with the Name of the Table
being the contents from Text Box 1 and Text Box 8.
Does anyone know if and how this can be done without using VBA?

I have a table with one address field of street address, city, state and zip
and need to split them into 4 fields. Is there sql I can use in an update
query to do this? I used one to split the name field into two  fields --
Left([fullname], InStr([fullname], " ") - 1) and ...

I have a recurring problem.  Table A has these fields in each record:
Account - Month/Year - Edition - Amount
For any account there are records for each month + year, and for every
account + month + year there are records for several different "editions".

I have the following VBA code that is supposed to insert values into a table
based on a select statement and a variable.  lngID is a variable that is
being defined earlier in the coe.  
What am I doing wrong here?  Thanks in advance for your help

I have a query that needs to display only the records that the field [Title]
is blank or "Project Manager"
I get only project manager or nothing at all.
Please help...

I have a query where I am looking at forecasted vs. actual hours charged.
Hours are forecasted by months.  And charged weekly.  Both are pulled into
Access from other programs.
Heres the thing.  The dates are pulled in as: 2/15/2008.  Since I want to