I want to apologize ahead of time for being a novice with MS Access
and VBA.  I desperately need help with 2 queries that I am trying to
put together.  I want to thank anyone that can help me out with this
situation.

I am trying to remove spaces between words in the db and replace does
not seem to be working.
I used it in the query window. may be I am not entering it properly.
my query:

I have data like 02042007
I would like to update it so it looks like 02/04/2007 how can I update this
with a query?

I have a table (tblDates) that contains all the available dates and the max
number of times that a person can sign up for that date.  in the query,
(qryDateCounter) i count the number times that a person has signed up for
that date, and i want to limit them to the max number from ...

Please kindly assist.
Every time I try to click the OK butto to open the report that I have created
It passes an error of
Run time error 2585, action cannot be carried out while processing a form or

I need a little help (maybe a lot J) … I am stuck with this statement.
This is in an update query
Two linked tables by the ProductLine
How can I fix this statement to work? And where does it need to be

I need to make a table using fields from a linked Oracle database.  The SSN
field in the Oracle database is a Number, not text.  Where there are leading
zeros, they are dropped.  I need a way to replace the leading zeros in my new
table.

I am trying to remove spaces between words in the db and replace does
not seem to be working.
I used it in the query window. may be I am not entering it properly.
my query:

I have created two tables so far in Access 2007 - raised stock (new stock)
and current stock.
I would like to enter new stock details in the raised stock table, then this
will be automatically added to the current stock table by pressing a button.

I have an access question. On a test I am giving this is the question:  
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0)   What does the ! mean? Thanks,
Vicki

Here it is:
I have a form which contains the opening date and the resolved date
and I'm trying to workout how many days it takes from opening to
resolution. Is there a way to write a sql query to do this? Or can I

I have a sub table with a subform that has a new field (a text field).  There
is an number field connected to another table that will have the same record
number listed a few times because it has multiple defect codes (the purpose
for the subform).  

I'm trying to run a "make-table" querie that will create a table on
protected database but, every time I try to run the querie, I get a message
saying that the password is wrong.
The command line that in the querie is

I have an update query which I'm using to write data from another Access
query into tables from an external non-Access database (that I've linked via
an ODBC driver).
When I try to run the query it asks me to manually input the parameter

In Access 2003, I have ONE table with student information, including
'ParentName', 'Address', and other fields - one record per student.  I'd like
to produce one mailing label for students with the same parent name and
address, but also include the student names on the label too ...