change data type

J

JG

Hello again,

I made a make-table query to combine any records that had the same (say)
userID. To do this, I had it sum (say) the Fines column for each user.

The original Fines column is Text valued (comes from a text file .. needs to
be stored this way).

The resultant table, when I run my query, is perfect except that the Fines
column is now Number valued. Can I change this back to text in code or in the
query somehow?

Thanks,
JG
 
Top