How to?
At the moment I have 6 linked tables that have data I need to search &
extract from. To do the searching I have 6 'types' of queries & forms to
each tables record eg: 6 select queries, 6 append queries, 6 delete queries,

Is there anyway in Access 2000 to be able to create a SQL pass through query
without a user having a ODBC driver created in their ODBC connections?
Thanks in advance

How do you make a list in either a query or in a table
Ex:
   1.  Directions
   2.  Preferential seating

Can you use the And/Or operators with a Like statement?
My example: WHERE [College Courses] Like 'CHM:###*' or Like "MTH:###*'
It keeps giving me a syntax error, but I don't understand what the problem is.
Thanks for any help you can give me.

I have a query that needs to get all the employee records that have not made
a cobra insurance payment within a specified month.  Each employee should be
in the General Cobra db (primary) which is joined by ss# to the Payments db.  
I'm trying to match the ss# in each database and ...

I am using access 97.  I seem to have a problem when using a parameter in
the query criteria and would like to know if this is a bug, or am I doing
something wrong.  What is happening is I get no data if I use the parameter,
but if I go inside the query and add the container ...

I have a table containing following fields:
Brand name, Manufactor, Contact name, contact mail, and Phone
The Brand  name is unique. But the manufactor might have several brand names.
I want to create a query that shows a list of the manufactors, but they must

I am fumbling around building a database without actually knowing SQL but
using the tools in ACCESS.
I have written a query which counts the number of values in a field. I would
like it to calculate it as a percentage but not quite sure how to do this.

I have a rather lengthy question in regard to updating a field based on the Previous record's input. We have electric vehicles that utilize batteries for their operation. There are 13 vehicles with approximately 2 battery changes per day in a group of 28 batteries. As an operator ...

I have been learning to control Excel and Word from Access using VBA and
references to these two apps.  I've had pretty good success, but I ran into
one, stubborn problem.  My Access application uses the TransferSpreadsheet
method to populate some Excel worksheets.  It then opens ...

I deleted some records from a query. Obviously I gave no attention to the
message that the records could not be recovered if deleted. This resulted in
deletion of the relevant record from the parent table. Could some one help me
retrieve those records. Both the table and querry ...

My query contains a number "Yes/No" multiple choice answers to survey
questions. On a few questions, respondents can select "Other" and fill in
something other than a yes/no.
So, two issues:

I have a address book that has a master list of all the names in a listbox
with textboxes showing individual names and info.  I want to be able to click
on the name in the listbox and have all that individual's info show up on the
form or if you have someother way to do this ...

I am trying to work out how long it takes for a query to be resovled.  I
thought I had worked it out but when it takes more than one day to resolve
the problem I get a negative answer; i.e reponse date & time 16 May 16:00,
resolution date & time 18 May 09:00.  If the query is ...

I have 2 tables that were created by importing from 2 spreadsheets in excel.
Table 1 lists procedures/locations/equ1/equ2/equ3/equ4/equ5
Table 2 contains the crosswalk of what the equ represents by number and
description. For example table 1: