Using Access 2000.
Is there a way to create a make-table from a crosstab query? I know I can
create a crosstab query (QRY 1) , then create another query using that
crosstab query (QRY 2), but I'm wondering if I can create a make table

I have a somewhat long Query that pulls from two tables.
When I add WHERE (((tblTrackingData.EXTENSION)=True)......
It does not give me only the True EXTENSION.
Here is the code:

Running Access 2000 SP3.  When I run an "unmatched" query - on a list of
items against an item master table my result is picking up a LARGE number of
items that are actually in the item master table.  Running same query on
another machine with Access 2002 I do not have this ...

in my Query  i have the following fields dateofS,stationName,PetrolSales...
dateofS field have date values like 02/09/2005, 03/09/2005.....etc.
in my report and chart (yearly report and monthly report) i have to  display
no.of months and also days. exactly.(because some time data ...

I am trying to create a query where I need to perform a calculation and/or
function to help determine the field name.
The situation is this........my table has a serries of fields named
BudgetPr1, BudgetPr2,....BudgetPr12.  A budget for each of our 12 fiscal

I have a table containing a Voucher_Number field and a Status field.  The
Status field data type is text, and records contain values: Used, Expired,
Void, and (here's the problem) a text string of unpredictable length followed
by three spaces then Used e.g. "K7SWDS   Used" or ...

I have several checkbox fields in a query.  I want the checkboxes,  "if= -1"
to show in another field on the query, the checkbox fields will not show.  I
have created the first IIF statement.  Can I use Multiple IIF statements in
one field?  If so, how do I string them together?  ...

I have a parameter query which uses a combo box.  When I pull down a name
from the list it shows the report with that name.  Is there away to show all
records of the people in the combo list.  On the query the criteria is listed
as [forms]![parameter]![resp] and that works for ...

   For each group of participants I have two phases, Orientation and
Probation. I have the Orientation Start Date and the Probation Start Date
stored in a table for each group.
  Project completion dates are recorded in a seperate table. As projects

Hi,
Hope this makes sense, i am still learning the lingo and correct terms to use.
I have a form with a subform based on two tables with a one-to-many
relationship.

Hey folks,
I'm attempting to use a random password generating function in a query,
but when running the query, the function is only called once.  This
results in the same random password for all of my rows.  Can anyone

I am drawing a total blank.
I have simple table of three fields:
PartNumber, Location, and Price.
I need to make a query showing only the lowest price for each part number

I have tried to used the IIF then statement to do this but too many nests
have forced me to rethink.  Is there another function I should look at for
this problem?
I have two tables.  The first table dictates which field to grab from the

I want to close a query when I am done with it in VBA.  What's the best way
to do it.
DoCmd.Close queryname gets a type mismatch??????????????
Mike J

Access 2003 with Windows XP
I have two identically structured tables, with names, addresses, and phone
numbers. Within each table, the phone numbers are all unique.  For clarity,
let's call them table A and table B. Let the fields be [Name], [Address] and