Hi, Working on a Query in the MOS exam, I was asked for a single command that
would change "De" to "de". I don't remember if I eventually did a find &
replace or not.
But: I thought maybe I should have done an Update Query, so, teaching

Hello all , I have a table that I want to read that can't be put into an
autonumber so what i want to check is that the numbers are sequential so
if it miss a number I want to know about it.. so for instand 76544 then
76546.. I want 76545 to be put into a table.. any help would ...

I have the following structure:
An import table (import_mpl - local access table) that has data loaded from
an Excel spreadsheet, and 2 lookup tables that are updated / appended to from
this imported data (Supplier & Channel - linked Oracle tables).  I had

I have a macro with a series of append queries.  When I run the macro the
querie work correctly.  However, I created a command button using wizard to
run this macro.  When I click the button the macro does not work.  
Am I missing something?

is it possible to perform a lookup on a query
I want to do a look that counts from lets say 1 to 10
in this loop i want to look up
x=1

I know I can get the fields using openschema via ADO, but for various
reasons I could really do with getting the fields in table "x" with a simple
sql statement.
Any advice?

I am trying to develop a query that will have 3 left joins...of course I get
the ambiguous error message, so I created it using all inner joins. Hoping I
can get some help to use left joins to the "Activity_tbl":
SELECT Calendar_tbl.Date, Account_Class_tbl.[Acct Class],

[Access 03] I have a suppliers price list that I want to amend to my needs.
That is if RRP is <=5 then update RRP*2 AND if RRP is >5,<=10 then update
RRP*1.85 AND if RRP >10, <=20 then update RRP*1.6 on so on. When I run the
first update (RRP <=5 (then*2) the qry returns what I ...

I have a table of points with xy co-ordinates.  I have tried using
SELECT BETWEEN, but what I actually need is the closest point to my
test point.  BETWEEN seems to need limits, like plus or minus.  This is
kind of like basic collision detection. The table has an X field and a

I apologize if this posts twice.
I am perplexed.  Seems like it should be so easy, but...Can you help? My
table has:
Client                   PaymentDate              Amount

I have inheirted a database from our club where we acknowledge peoples
birthdays. I am not real familar with this database and would like
some help. I need to get this data but I need to only get this data
from people who are up to date on their dues. So how do I add a

Dear Ng,
I've got a tblDeerData on server A which I add records to on a daily
basis.  The data are scanned forms and auto export directly from the
scanning software to Access each day.  I have a copy of tblDeerData

I have a table that is storing information from electrical panels.  In my
table there is a column for circuit phase and another for actual amp load, in
the fields under the phase column the entries are either A, B, C, AB, BC, CA
or ABC depending on how many poles and where in the ...

In my database, my main table's primary key is a composite key of an integer
and a letter. The order entry form assigns Dmax +1 to create the order key
for most records.
However, we import some orders from another system into a seperate table,

Is there a way to change the permissions of a table (or other object)
via an SQL statement?