Looking for a tool, or code that does the following.
Edit [partial field data] in TBL1, if [partial field data] meets criteria in
TBL2, COL1.  TBL2, COL2 has the REPLACE WITH information.
Not sure if this edited data can be written directly to the TBL1, or needs

I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update query
to run in the background, and not ask the user for any perrmissions. I
was thinking to run the query as part of the autoexec macro.

I need to compare the MCDID from one table to 2 other tables that contain
multiple rows for each member due to effective and expiration date changes
and return a single row with the member information for members whose MCDID
is in the first table and who were not active for ...

I have a large database of contracts that includes: fields = SSN, Yr, and the
like.  Years span from 1999 to 2005.  Each contract record includes an
individual's SSN.  However, most individuals have had multiple contracts,
some in different years, some in the same year.

I have a crosstab query and I need a chart based on this.
I have formatted the chart and when I select the data in the criteria
section of the query ("electricity" Or Is Null) the chart works OK.
But when I use the Expression Builder to select a LedgerAccountName

I have several access Append Querry that uptodate daily data from one table
to another table, I want to schedual these queries run everyday at
12:00:00AM, I like to know is there any commend in Access like SQL Server
that I can Schedual my job (Running Append Querry, or any ...

I have a table, with times stored for comptetors in races,
With the kind help of Allen Brown, I am now successfully storing in a
query the time for the competitor, and the previous competitors time,
with the aim of showing a time difference

I spend a lot of time working with property data from different counties.
1. There are usually multiple sales of the same property (same parcel ID)
that I want to combine.
2. The MLS has additional info for the same address but does not contain the

Please help me.  My email address is wolftor@hotmail.com
I have 2 tables:
Table 1: Types
Company    App    Type

I have posted a related issue here and in the Excel daoquery thread before,
but I have narrowed down the issue and, with apologies in advance, am
reissuing a new question thread. I am posting in both places in the hopes
that someone has some insight.

Hey everyone! OK, I'm a little stuck. I have an append query with 3 fields,
EmployeeID, Premium & Premium Month, that append to field of the same name in
a table. The 4th table is UNUMTerminateDate. When I run the append I type in
a date to be entered under PremiumMonth. This ...

I have a report that had been working fine, but now is not.  When I go to
the design view of the query, I get the error that the field(s) could not be
represented or that something has changed.
I have even went as far as recreating the query and here is what I have.

I have an Access 2003 database that has several tables in it that are all
related to a client table and have the cascade delete enabled.
I wish to delete all clients that have not been seen for two years or more.
A "meal" table contains the last visit date.

I have a crosstab that shows how many times a student missed class per term,
where missing a class can be one of three types: "Late, Miss, Threw out".
Since each miss has a mandatory date assigned to it, I count the date to get
the totals:

hi all,
I have the following:
rst.Open "Select * from tbl_IDCF_Questions where" & sSQL, cnt
However, at runtime, I am getting an error message that says "Run-time error