I am using MS-Access 2003.
I have 2 tables. 1 table is from a previous db, the 2nd table I created.
I want to compare the 2 tables for individuals, by lastname, & the display
the lastnames.

I have several tables that I have to adjust by one hour for time zone
differences.  Is there an easy way to do this?

This one has me stumped because it should be so simple.  The query I use is
this:
UPDATE uvw_NeedToReport
SET uvw_NeedToReport.MyFlag = 1

To anyone and everyone that may be able to help.  I have a database which is
currently being used to monitor the number of visits to various sites where I
work at.  I obtain a file each month which contains registration info for
each site. I then import the reg data into Access and ...

In the Query/field/Expression Builder
When editing text not able to cut and past.
Using right click with mouse.
This works in 2000 but not on 2003. Found same problem in other Office 2003.

I'm trying to write the SQL to import a recordset from linked tables.  My
current code is as follows:
INSERT INTO tblProject ( JobNumber, ProjectName, SiteStreetAddress, SiteCity,
SiteState, SiteZip, GCName, GCContact, GCStreetAddress, GCCity, GCState,

I can figure out how to report totals, grouped by an Element, for a specific
week:
SELECT Count(tblSAR.SAR_ID) AS CountOfSAR_ID, tblSAR.SAR_Element
FROM tblSAR

I'm not sure if I put this up already, I haven't gotten an answer but here
goes.
I have a query where information is pulled from my scope change table,
including Company name, Amount of the scope change and some dates.  I have

Ok gurus
I need your help, I am new to sql and access database, so easy on me, here
is my need:
 I have a table named table1234, within this table I have a field named

if i have a table like this:
4/3/2006
4/3/2007
4/12/2006

I have a table with an address field that I used a formula to trim down to
retrieve just ZIP codes. I have another table that lists all ZIP codes and
their associated cities. I want to be able to run a query that will convert
all of the zip codes in the first table into city ...

I have a view which selects these columns: employeenumber,ClientID,Billing
code,amountBilled,InvoiceNumber from a number of other tables.
One Employee may have many billingAmounts.
My view right now has each row for every Amount Billed for each Employee.I

I have a number value set to 1 as the default value. This number changes
during the year. But I wanted this value to go back to it's default value (1)
after one year.
Please help

I would like my Avg(Calls.TotalCumScore) to ignore Null Values and
Zeros.
SELECT Calls.Monitor, Avg(Calls.TotalCumScore) AS AvgOfTotalCumScore,
Count(Calls.Completed) AS CountOfCompleted

I have an employee list table including the standard fields first name, last
name, and others.  I also have a query & report that return employee-specific
data through use of a simple paramater query asking the employee's last name.
Now I have two employees with the same last ...