I need to change the data type from TEXT to DATE in one field of an
Oracle 9i table. I cannot do that while there is data in the column. The
existing data is formatted text in the form mm/dd/yyyy.
I need to copy the existing table, clear the date column, change the

I'm hoping this doesn't violate this site's protocol, but I've reached the
limits of my capabilities constructing a MSAccess database which I'm using to
populate some ASP pages for my company's website.  I need 3 queries which are
fairly complex (though not for some of the pros ...

I am trying to add a field to a tab control page but each time I drag it to
the page it adds it to the other pages of the tab control also.  I know I had
this problem before, but I don't remember what I am doing wrong.
Your help is appreciates.

I have created a search query within Access 2002 which looks for partial
details within a field as below:
SELECT Stock.[Stock ID], Stock.Description
FROM Stock

I have two queries that were working fine using left outer joins.
The first, ALLPASTCLASSES, still works great and in SQL (which I really
don't work in much) looks like this:
SELECT Schedule.ClassCode, Schedule.Date, Count(Attendance.EmpID) AS

I am getting an error message with my SQL statement.  It says
"syntax error (missing operator) in query expression 'Unit_Names.UnitLong
WHERE (....)".
my code is:

.

I have two table; TableA and TableB having the same structure. TableB has
some records that do not exist in TableA.  How do I write a Query to update
TableA to INSERT records from TableB (ONLY RECORDS THAT DO NOT EXIST IN
TABLEA).

In my table I hve a field named photoCount, which contains the total number
of photos related to this record, and one called Photo, which gives the name
of the first photo (this is based on oanother field).
I need the synatx for:

Access 97. I've got two tables. The first table has 3 fields. Sample data as
follows
A   06/01/2005   06/07/2005
B   06/08/2005   06/15/2005

Hi.  I am very new to access, and I want to copy data from multiple tables
into one table, based on criteria and such.  I have tried an append query,
and I do not think that it will work.
I have many tables, but these are those that are involved:

I'd like to create a query that checks for duplicate records and deletes the
record that, on an autonumber field, has the smaller value?
Thanks.

I need to check for a date in three fields use the following [Please enter a
date:] in the criteria field.  The fields are Date1   Date2 and Date3.  I
need to print a report showing the fields.
Example record 1  date1 6/11/2005   date2 6/12/2005  date3 6/13/2005

I have a form based on a user input query (single field, which is indexed)
that pulls data from a linked table with over 376,000 records (and growing).
It takes several minutes for the query to run before loading the report.
Users are impatient, and I'd like to improve performance ...

I am running this query below which aims to consolidate the data from a
table called Fin0AllAustria into a table called Fin0Austria.
Fin0AllAustria's primary key is SE (an ID number), RS (which can be 'R' or
'S') and Quarter combined, while Fin0Austria's primary key is SE.