When I use a query such as below for a crosstab query source it gives an
error message that it does not reconogize T.Column1 as valid.  In the past I
have used the query to make a temporary table then the table as source for
the crosstab.

I have a system which allows us to enter our room hire & training bookings
room requirements to ensure we have reserved the rooms we need.
I have 2 tables:-
Room Data (Room ID, Room Name, Capacity, Cost)

I have a cross tab query to show date, time, customer and staff as a
schedule. It should look like this:
DATE   TIME    STAFF1   STAFF2   STAFF3  
10/19   08:30  Smith                     Jones

I have a query to import and export a file into Excel.  It is received
each day with the name of the file and the current date in the title
and it also needs to be exported in the same fashion.  Is there an easy
way to include this in the programming?

If I have a table that looks like:
name    partA    part B     part C
model1    5%     7%          88%
And I want it to look like:

I have a partial solution to a problem I am having.
I have a field called description. In that field I want to check if it
includes some characters and remove them. If it does not then all is
fine.

I have two queries that I want to make into one query so that the information
can be pulled into a form.  I have read some information on the Union query
and was wondering if this would work for what I need to do.  Here are the two
queries that I have and that I need to try to ...

I am a self tought user of access... Im eager to learn expression building
please help me some. I have built a db on my job and need to add
calculation(s) where and how do I achieve this aggrivating task....for
example:

I have a table with ProductID, TrxNo, RecvQty, IssueQty.
ProductID, TrxNo, RecvQty, IssueQty
===================
Item1,Trx01,100,0

I have a Report that does not work when I do not utilize as much data in my
cross-tab query.  My report is build to handle some fields that may not show
up when I am only looking at a short window of data.  When I expand my query
to a large date range I have all of the data fields ...

I am creating an address list for parents (billto) of children (patient).  If
there is an address for the parent, I want to include that address in the
list, otherwise if there is no address for the parent, then I need to include
the child's address.  (i.e. If billto.address1 is NOT ...

I am starting to send out quarterly surveys for my internal customers at
work.  I need to keep track of who I am sending the survey to and when they
completed it.  
I am keeping track of this data in Microsoft Access and I would like to run

I am looking to create a query with the result being a sum of the number of
events that happen with a specified period.  To clarify, the database table I
am working from has a column with a person_id and one with event_date.  i
would like the query to sum (for the aggregate ...

I have a query with a [PaymentAmount] field.
When the query runs, it should check the value in the checkbox of
[forms]![ExcelExport]![txt100k], and if the value is False, the query should
select records whose [PaymentAmount] is <100,000.

I have a few fields in a query that are calculations.  The calculations are
being carried out to ten decimal places.  Is there a code I can put in the
critera of the design view to have the calculations be carried out to only
two decimal places?