How do you link two drop down boxes. I want whatever you choose from one the
other one has certain choices because of the first thing you choose

I have three tables: Classes, Students, and ClassStudentLookup.  I want to
populate the Lookup table from the other two tables using an Orthogonal
query.  If Classes has 3 records and students has three records, I want the
Lookup table to contain 9 records.  Student, Class is the ...

I can't find the roght way to query time as in greater than or less than. For
example what stores that are open after a certine time.

I have a table (tblAddress) that lists pickup addresses for taxis and a
subtable that lists the number of times a client calls in (tblCalls) for that
one pickup address.  
I also have a table (tblBackup) that lists any vehicles that was sent as a

I've tried to do my pre-post homework but I'm coming up short....
(Access 2000 by the way)
I have a main form (frmCalendar) with two multi-select list boxes to
dynamically populate the subform(s).  There are two hidden textboxes

I have two Name fields I want to compare, the fields are identical except for
a comma in one of the tables separating the first name and last name.  In the
second table they are separated by a space.  How do I get Access to recognize
and match either partially similar or similar ...

I am trying to create a query that will display all records except for ones
that I have listed in the criteria.
The format I am using is <>record1 or <> record2 <> record3... If I do this
for only one record the query works and returns all records except for the

Is there an SQL statement where I can search all fields in a record without
specifying the field names?
such as: Select * from [table] where * is like "whatever"
I would like to use a simple query as the field names can change from time

SELECT tbl_Projects.[ProjectName],
tbl_Projects.[ProjectNumber],
tbl_Projects.[ProjectManager],
tbl_Projects.[OnsiteLD],

I want a query that will show memebrship expiry dates within 31 days of a
date I can enter by a box coming up when clicking to run the query.

I have a table that look like this:
Rank 1    NAVY    BLACK    TAN    CHRCL    SPRUC
LONG     1.3               
LONG     10.4    0    0.965       

I use [From:] and [To:] as parameters in the criteria area for a column of a
query. I also have [From:] and [To:] columns. For the most part, when the
query is invoked, I am only asked once for each date. But sometimes, I am
asked twice!

I have a ralatively straightforward query that returns the minumum and
maximum cataloging numbers grouped by year. To weed out typos I want to
return a trimmed value, that is, removing 3 - 5 of the highest and lowest
values in the list.

I'm working on a Microsoft Access query.  I'm trying to pull a query on
classes taught by faculty for their departments.  Some faculty teach 1
section, most teach 3, and some teach more than 3.  Each class is in a
different row in the database.  (They are stored with numeric ...

When trying to submit data to an Access database using ASP.NET I recieve the
following error:
[OleDbException (0x80040e14): Syntax error in INSERT INTO statement.]
  System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)