Is there a query i can run which will remove any spaces from within a field?
thanks

i have a field for which I want to remove the first three and 6th character.
How would i go about this please - I assume I need to run two queries?
Thanks
A

Hi, I'm a Newbie to Access who has just created his first drop down list
box. It is working fine, but I would like to have the data listed in
alphabetic order, rather than the order I originally entered it into the
table. Sorting the table into alphabetic order doesn't seem to ...

I have a case where
I need to have a status column
and there will be 4 types of status so
i need multiple if then statements i don't know if its possible

I am getting the above error while trying to insert the records.
strtstNIV = "2"
       StrSQL = "Insert into olyfweb_fdbdoc (tstNIV,tstRAC)" & _
   "Select (""" & strtstNIV & """,qrytabtest.[JURACI])" & _

I have a table that holds information on a job queue. The next job to
be run is the record at the top of the table. The first column is being
used to hold the Job_ID, when a job is inserted into a table it is
automatically assigned  a Job_ID. When the job is ran it is deleted

I am trying to return a RowNumber by Rank based on size,grouped by
department with an output like the following:
Dept      Size    RowNum
East     10        1

I have a query that correctly returns 149 rows. I immediately run it
again and get 148 rows.
About 2/3 of the time, one row is missing - but its different row each
time.  A couple of times, more than one row was missing. The underlying

My database is like so:
record    name    type    new field
1    sam    current    current-sam
2    bob    future    bob

As the result of querying a crosstab query ,  I have a fieldname
rejected by Microsoft
the fieldname is simliar to this
qryACE +X + Y + Z .qryACE + X.Year.Year

I was running the Access Documenter and had to halt it in the middle because
one of my forms was still open. Now when I try to run it I get an error about
the doc_tblObjects already exists. I'm guessing that Access did not cleanly
exit the Documenter after the error and now is ...

I have three tables: tblStores, tblWeeklyInventoryCounts, tblProductList,
qryReportDates
The tblStores contains a listing of all stores that are currently open and
which should be reporting data each week

I have a field called OCLC# . From that field I want to extract just
the numbers that come after the letters ocm. If the field does not
contain ocm, then return a  0.
Here are some examples of data that are in this field.

I have a list of contacts in a contacts table and  list of activities
in activities table that includes all interactions with each client.
In each activity their is a 'status' field.  I need a way to bring up
the latest 'status' field value for each contact.  The latest would be

I am trying to insert a record in Linked table through ODBC setup. I
got the confirmation message as "You are about to append 1 rows."
After the inserting, I checked the table but the inserted the record
not found.