Access 97 field types.

  • Thread starter Thread starter Cherie
  • Start date Start date
C

Cherie

I've read in several places that when an Access 2000 query
pulls data from a table, the field type/size is
inherited. Does anyone know if this is true for Access
97? My data is getting truncated when I run the query.

PLEASE HELP!

Thanks,
Cherie
 
Could you describe an example of how it gets truncated? Also, provide the
SQL of your query. Access 97 queries will inherit field properties. I expect
your query cuts off memo fields at 255 characters. This is usually caused by
phrases in your query like "DISTINCT", "DISTINCTROW", "GROUP BY", "UNION"
 
Back
Top