Update a table with a crosstab query

[Molasses26]

I am trying to update a table with the item counts from a crosstab query but
I keep getting a Datatype Mismatch error. Is this even possible or do I need
to create a function to do this instead?

The table I want to update has these columns:
Date, ID, Pending, Tickled, Worked
Date is a date/time field.
ID is a text field.
The Pending, Tickled & Worked are all numeric fields set as long integers.

The crosstab query is based on a table that has column
Date, ID, Status
Date is a date/time field.
ID is a text field.
The Status is a single character text field and I am counting the number of
P's, T's and W's there are on each date.

The reason for this is to establish a stats table of how many of their
assigned items each ID has at the end of each day to help the supervisor can
monitor performance.

Thanks for any help you can provide!

 

[Molasses26]

I have narrowed the problem down to the date fields. In the Stats table that
I want to update I have defined the field as a Short Date field. However in
the table I created the crosstab on the field is actually a date/Time field
and I am using Format(<<expr>>, "Short Date") to convert it and remove the
time stamp. I have tried using both the Format() and Format$() functions but
neither seems to make a difference. I even set the properties for the field
in the Query as being Short Date but nothing seems to work.