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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Access 2000 talk to 97? 8
How to subtract a number from a Mergefield? 0
Access #Error & Excel Pivot 0
Can't create a report from my query in Access 1
Difference in size of actual access database and its backup 0
Change field length in Access 97 file format(Access 2000) 5
appending more than 255 characters into a Memo field 13
Make Table Query Truncating Memo Field at 255 Characters 2

Back
Top