I am trying to set up a filter that will allow users to enter specific dates
in "from" and "to" fields and which will then query specific results which
fall within that date range. The catch is that I only want the filter to use
these dates when a specific option button is ...

I am trying to right a query that compares 2 different records based on 2
diff. fields all in the same table.
ex.
column 1     Column2

I'm still quite new to Access. I've built a query to pull course details
from the database. Unfortunately it seems to be causing problems and a part
of it is crashing access giving no errors.
I've identified that the following is the problem, but I can't see why. Can

I'm not that familiar to Access and would appreciate some help building the
following SQL query.
I have two tables, and if two categories match within the tables, then I
would like a third category entry updated to the first table.

I am trying to make an update query but have some performance issues...
I need to compare a folder with pictures to an excel file, to see if the
pictures exist in the excell file when they exist in the folder...
I want to create 3 different things:

I have 2 queries one to get the data and another to group and sum it but for
some reason when try to sum the data for the second query the numbers are way
to big
the Sql for the 1st query is

I have an ODBC connection to a table that has a date field associated with an
ID.  The problem is the software creates multiple records everytime a
schedule is created or updated.  So one person can have 5 or 10 different
records.

My company is converting from Oracle to SQL Server 2005.  My front end is
Microsoft Access 2003.
In the conversion, they changed our customer and transaction numbers from
decimal fields to BigInt.  When I do a make table query in Access, those

I think this is a simple query but I am not well-versed in SQL so I cannot
figure this out.
I have the following tables (I show only the relevant stuff):
Documents

I have a report generated from a query. The field names are add1, add2 and
add3, productname. The data in the fields: add1-add3 are the same. I would
like to be prompted when I open the report for the data in fields add1, add2
and add3.

I have a table that contains all the classes for 3800 students.  Each student
times 7 gets you around 23000 classes, each record contains:
SSN, LocalID, Name, Subject (ELA, Sci, SS, Math are the only ones I care
about), Class Level (1,2,3,4), Teacher Name, Period, and Course Name.

I have a number of queries that are built upon certain tables.
I have now added a number of updated tables and would like to use the same
queries on them, instead.
So far I have been going into Design View, adding the new table to the grid,

I have a button I need to use in a form to run the following Append Queries
Aerial Lift Append, CPR Append, Defensive Driving Append, Flagging Append,
Forklift Append, Ladder Handling Append, and Pole Climbing Append
I am using this for the Aerial Lift Append but want to be able to ...

I have to tables.
I want to create a query which will show the records of table A, but if any
of these records appear in table B, i want them to be omitted!
Can this be done?

I have a table for employees called employees grades. This table has 4
fields, emp ID, Name, grades and grade number. The grade number is
increasing, e.g , in the grade number 1, the value will be for example 20. In
grade number 2 the value will be 10. What I want to do is making ...