Access 97 field types.

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
 
D

Duane Hookom

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"
 

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

ASK Field Formatting 1
Adding data to MS Access from csv file 0
Some mail merge fields not pulling into document 2
Access Query to import from Sharepoint 0
Internal Data Integrity (Type 4) Details Needed 1
Can Access 2000 talk to 97? 8
Memo Field Truncates my Data in Table?! 6
Make Table Query Truncating Memo Field at 255 Characters 1

Top