I created a crosstab that does exactly what I want, but if you create a
report based on the crosstab and the data changes, the report crashes...
How can I make the column headings in my crosstab vertical so that I don't
need a report?

I need to use a crosstab query with a "parameter query" (user enters dates)
and understand that I must define the parameters in the crosstab query - but
can't get the bracketing right, I have tried most combinations and this is by
latest failure

I want to delete all but one of the records that have duplicate values in one
field. In query design I have tried setting unique value to yes but that
leaves me without the other fields I need. I don't know code well, so is
there a simple way to use the unique value method but ...

Michael
I am ending my practice with Access. Unfotunately the books and articules I
read didn't help me to much to do some of the operation I needed. You help
was extremely valuable.

I've posted an example of the Query results I would like returned from
my Data Source.  Basically, I want to have one row for each item, then
have columns for the Months and show the Qty for that Item under the
given Month.  I know I can get my desired results using VBA, but was

I've posted an example of the Query results I would like returned from
my Data Source.  Basically, I want to have one row for each item, then
have columns for the Months and show the Qty for that Item under the
given Month.  I know I can get my desired results using VBA, but was

I created the below query to find out from which employees I am missing
information.  I thought this would create a list of only employees with any
of these listed fields empty.  However, my results will list everyone.  Did I
do something wrong?

I have 3 tables, one for internal bookings, one for external bookings, and
one for the transport.
the transport is the focus here, and I need the other tables to export their
data into the transport table if the checkbox "boolNeedsTransport" is ticked

For some reason I can't seem to get this to work and was hoping posting here
would speed up finding the resolution.  
I have a form that the users a specifying a value from based on a list box.  
The users press a button on the form after doing the selection and it

I have a Customer table that has fields such as CustomerID, CustomerName,
ActiveClient, DateModified, Address, CustomerType etc.  I also have field
called CustomerLicenses that has CustomerID, CustomerName, ActiveClient and
then some other field that are not in the customer table ...

In our vehicle database i have a main form with vehicle details and
subform where the mileage is entered for each week.  The week no an
mileage is entered each week based upon a paper form drivers fill i
each week.  I would like a query which displays which mileage value

I have a query issue.  It's a bit complicated, so please bear with me...  
I am running this query,
SELECT SSRS_SRS_AD_HOC_COMBINED_V1.ISSUED_DATE,
SSRS_SRS_AD_HOC_COMBINED_V1.REVIEWED_DATE,

I have a table with following colums and data types
String    yes/no    yes/no        yes/no
Name    Boss    Supervisor    Employee
and the data in the table:

There are 2 column in this query:-
Column 1      Column 2
A                       A
B                       C

How do I update a field in Microsoft Access with the RowID of each record?  I
don't want use auto number in the table as I would only like to populate the
rows in the table which have been extracted by the query.