I am reporting on training and need to include YTD training for each month
as well as the current month. Currently, I have a crosstab query which
collates the YTD training, and another crosstab which collates the for the
current month. I then combine them into one big query to ...

Using MA 2007 ...
I would like to create a new table from the output of a query.
Can this be done ... if so how?
Thanks

I have a query that assigns row numbers to the recordset returned by another
query:
SELECT Insp1.RepairDate, Insp1.DetailID, Insp1.UnitID
(SELECT Count(*)

Apologies if this is an obvious question, but I can't find any suitable query
function or operator.  I have a series of tables with RI enforced foreign
keys.  When keying data into a given row, I want to be able to limit the
combo box values by a value I have already entered on ...

can you write a syntax that says if text in one field is "x" take the date
from another filed add 45 days and populate a third field
any help would be greatly appreciated

Thanks in advance for your help. I posted this in a previous thread
but I'm afraid that it's faded into oblivion.
Two things happen when I click my preview button:
- If I make a selection in the listbox the report opens BUT every

Might there be a better way?   I am trying to pull text from a field in one
table and then assign those records to that result.  For example, if the
printer name contains "gen" it is a member of the "Medical" department or if
it contains "acct" then it is a member of the ...

Is there a way to select a different top value or percentage of the queries
results from a form?
We have four different types of auditing based upon the representative's
team number:

Is there a way in a query to have let's say three fields and do this:
If this field is not null OR if this field is not null OR if this field is
not null then do something? Is that possible? Thanks so much!!!!

tblClasses
-----------
I thought designing this query would be easy, but it's turning out to be
harder than I anticipated. Obviously I'm doing something wrong.

I need to see all records where the field AssignTo is null or has been
assigned to a specific person. If the checkbox is true all records with null
value AssignTo are displayed. If the textbox [Forms]![frmReview]![AssignedTo]
is null with the checkbox true only the null AssignTo ...

I have a query that has presented the following result: Name, Competition
Name and Playing Option.  I also have a separate table that contains the
Competition Name, the various Playing Options for the Competition and the
Cost for each of the options.  This table is not linked to ...

Is there a shortcut to updating the table name that is in all of my Queries?
Each year we start with a new table again and I have to go in and manually
change every field of every query from the old table name to the new table
name.

So after trying about a million things, i figured out how to use the switch
function, but now for some reason it is excluding some records.  When i run
the switch query it comes up with 2464 records, and when i run the query just
of that field i get 4786.  I did include null ...

I am working on a query to show the vendor_name and the total number of
pieces the user completed for a certain date. I am pulling the info i need
but having problem with the calculation for the totals.
TRANSFORM Sum(sku_information.item_type) AS SumOfitem_type