Simple Query from Two Crosstab Queries -Result Format Discrepancy

C

Carol

I am working on creating an application for tracking data,
compiling comparative results, and calculating compliance
of resultant totals. I have utilized a variety of simple
and crosstab query combinations to get the results I
need. With one exception!! The results of a field in a
simple query built from two crosstab queries do not match
in format. In the original table the data type is Text;
the crosstab queries display the result in text format.
The simple query, built from the two crosstab queries, is
showing numeric values which appear to be the record
number in the original table.

Anyone have any suggestions? Thanks in advance!!
 
Top