Hi Carol,
We'll need a bit more info to help. First of all, can you post the SQL of your query? To do this, go into your query in Design view, choose View, SQL View, copy what's there and paste it into your reply. Secondly, for each field in your query, can you tell us the data type of each field?