I am working with the following Query:
SELECT tblEmployees.LastName, tblEmployees.FirstName,
tblPositions.Department, tblEmployeePositions.Status,
tblEmployeePositions.PositionHours,

I need to provide variable source table names to a query.  In other words, I
don't want to pre-select the tables that will be used by the query by adding
tables using the query editor -  I want the user to be able to select these
source tables at run time using multiple combo boxes ...

I'm not very familiar with access in regards to SQL...I have two tables
with physician info. The first table (OCphysicians) I've kept and
updated as we receive new physician info and have had it a few years
now. The second table (MedBoardData) I recently received from the state

I don't know if this belongs in the Query or Reports area.  I have a list of
requirements, say R1 through R8 (see example below), where several of them
are children of other requirements, in this example, R1, R4, R6 and R7 are
children to other requirements.  I already have a ...

I have a database with 20 fields, and a several hundred records.  In six
records, field2 contains an abreviation, and field3 contains the full word
for the abreviation - all other fields blank.  In the remaining records,
field3 contains any one of the 6 abreviations found in ...

On the query grid for a date field I can hardcode #5/7/2006# but find that
using #may/7/2006# is more reliable as it's specific and unambiguous, ie is
it May 7 or July 5 that I want.  Does the local machine setting do the
determination when using the #5/7/2006# format?  Is my ...

I have created a Select Query, I have 3 columns of data, I'm able to create
calculations on rows, but not columns???

I have this union query (below) that joins two tables. However, when I create
a new query with the union query as it's source, I do a sum on the [Bill
Amount] with a Group By on [Vendor], expecting to get a total on bill amount
with 1 vendor and all the rest should roll up to a ...

Is it possible to have a linked table to an Excel spreadsheet and allow many
user to read ONLY the data.
I know that an Excel spreadsheet cannot be a multi-user document, but what I
want is that many users get connected to the Access database and view the

I have two name fields, name1 and name2. Every record has name1, some records
have name2.
I want a combined field that looks like:
name1

AT MY DESKTOP YOU CAN SEE THE START, PROGRAMS CLOCK ETC. ALONG THE BOTTOM BUT
ONCE I OPEN UP EXCEL, WORD OR OUTLOOK MY TASKBAR NO LONGER APPEARS UNLESS I
GO BACK TO THE DESK TOP.  I AM RUNNING WINDOWS 2000 AND JUST STARTED HAVING
THIS PROBLEM.  I WOULD REALLY LIKE TO SEE THE ...

Is there any way to have 1 query to append then delete the records that were
appended?

How do you change a query to a crosstab query?  Make a crosstab using the
query?
Thanks,
Fly Boy 5

Fairly basic question I'd say, but I'm stuck!
I'm running a DLast function in a query.
In the criteria section, I want the date to be less than or equal to a date
in another table, is it possible to reference another table in the function?

This might be a silly question but;
How do I make a criteria question when I got a checkbox?
If I type "<[Yes or no]" in the criteria field I just get an error saying
something like: