Could someone help me, please. I am new in Access programming.
I have the following query
SELECT MP06.TER, MP06.MEST
FROM MP06

how do i delete records that start with the letter s

I have a database that collects time stamps of material movement through a
certain area.  It's great for collecting metrics.  This initial loading of
data, however, requires that they enter the Dock Date of the material and we
do not know the time this happened -- only the date.  ...

We switched our 2003 Access program to a 2007 Access program and are trying
to run a query to find an address or name but the search doesn't work. Only
can find the search in 2003. Seems to be a sorting issue? Is there somewhere
in 2007 that I need to click to turn on the query ...

I have a master table with each row representing a unique record. My
colleagues need to have exact copies of this table in which they can alter
any of the unique records and then send their altered copy back to me. The
altered records from each copy then needs to replace its ...

I have a database with a table and a number of fields within it.
Every now and then I need to query the table and produce a subset of
the data.
I will often need a sequence number within the table (this does not

Hi, I am trying to determine the actual number of characters within a
field [CustomerAnalysisCode]. The field length from the underlying
table is 2, I have tried Length: Len([CustomerAnalysisCode]), but this
alway returns 2 Irrelevant of the the actual number of characters: for

I would like to add a few conditions for below query but I dont know how I
write it. Could someone help me:
Rows that have the below combination should not be shown:
Account=1462 and Asset_Liability = L,

I am extracting phone numbers from our HRIS system and there are several
types of formatting on the phone numbers.  I need the format to be consistent
- xxxxxxxxx - so I have constructed a SWITCH formula to address the
reformatting needs instead of using a series of nested IIFs.  ...

  The other day I was thinking that maybe in a few years some data would be
irrelevant to my company(ie fluctuations in market price and what not) and
that only the more recent information would be useful. So with that in mind,
I want to be able to set up my report queries to ...

Hi, I am trying to change the name of a field [OrderAnalysisCode] in
my query to something that is more relevant, but when I try
DeliveryLocation: [OrderAnalysisCode] and run the query
OrderAnalysisCode shows as the field heading when I expected

Been struggling with this to no avail.
I have a begin date record and a end date record,
and I would like to create the records in another table that corrospond.
Example, table a has 1-1-80 for the begin and 1-10-80 for the end, I want to

I have a database with multiple tables. I recently updated my customer table
in excel and imported it into my database. I deleted the relationship to the
old table and created a relationship to the new table. I re-created an
existing query to bring back fields from the new table. ...

What am I missing?  I have reviewed Allan Brownes probable causes to no
avail.  
I have two tables, each with Primary key "ID", autonumber and duplicates not
allowed.

The query below works great.  It returns the null values in the status field
as "Pending" and the other statuses as entered in the field.  I am also
trying to have the statuses "needs review" and "want order number" return as
"Pending".  I have built a little and tested a little ...