I tried to change the sort order of a form to using a query and now any
records that have no data are locked and I am unable to input any data in
the fields.  I just created a query that matched the field values of the
table I was using before and changed the source of the form ...

This query returns records for awhile but then errors with an overflow
SELECT tCS.Customer_ID, tCS.Vendor_ID, (SELECT Sum(Sales) FROM
tbl_Customer_Sales as tCS2 WHERE tCS.Customer_ID = tCS2.Customer_ID AND
tCS.Vendor_ID = tCS2.Vendor_ID AND tCS2.[Year-Month] Like '2005/07') AS

Dear Friends,
I would like to create a stored procedore in access 2003 database.
that stored procedure should to the follow
CREATE PROCEDURE.....

I use an ACCESS 2003 front end to SQL server 2000.
I am passsing a simple SQL statement
SQLText1 = "Delete A from dbo_tblBook_inventory A ,dbo_tblrhd_inventory b "
& _

I have a table named "WOStatus" which has a colume named "Status" and another
named "StatusDate". In the WOStatus field in my table i can select values
from a combo box like "New", "Closed", Waiting Payment" etc.
I want to create a query that COUNTS the total number of "new" ...

I am trying to compare two columns in a table where I can filter out the
names that are not matching with the other. My query seem to be OK, however
the results are also including the one's that are common in both columns.
I woul really appreciate a help here.

It seems the general consensus is that Iif statements aren't very efficient.  
I'm having a hard time, though, trying to figure out what to use instead.  
I've seen some posts on Switch, but I'm still uncertain how to use Switch.  
Can someone enlighten me please?  I have several ...

I have 4 columns.
Example.
ID   CK   KN               Sum
1    SE   6111.2090     643,11

I am trying to compare two columns in a table where I can filter out the
names that are not matching with the other. I
My query seem to be OK, however
the results are also including the one's that are common in both columns. All

I would like to be able to convert the numbers 1 through 300 to words.  This
would be very useful for a report that I am designing.  Does anyone know if
there are any routines or knowledge base articles available that describe
how to do that?

I have created a table from several queries results ( about 230 fields).
Then I created a query using all of the fields from this table with some
other fileds from another table, however  I get   "Too Many Fields Defined"
error.

I have a local database which imports orders from a SQL table from an on-line
shopping cart.
When I do the append query, I need add an identifier to indicate on my local
orders table that the appended record came from the on-line shopping cart.  

i'm using the system tables MSysObjects and MSysQueries to do the following:
1. use a SQL statement to select the object names of all Action queries,
open a DAO.Recordset, loop through the records, and append them into a table
called tblQueries.

Here is an example of what I currently have as a table.
LNAME      FNAME            EMAIL                     FRA    TCHR     MARK    
DOE           JON       JD@SOMETHING.COM       Y         Y      
SMITH        ROY       RS@SOMETHING.COM                 Y           Y

I have two tables:  Allocated and Product Lot Info
I want an expression called Unallocated to give me either:
- The difference in amount allocated from the Allocated table and the
Product Lot Info table