Record 1 contains too few data fields

[KingKaos]

I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith
(e-mail address removed)

 

[Peter Jamieson]

What is the data source? (by "query", do you mean "Access Query" or
something else?)

Peter Jamieson

 

[KingKaos]

Yes - by a query in Access

This is really strange - but it I added a field to my Query that was
spaced - eg. If I used Client Name, instead of ClientName - Word would
give me the "Record 1 contains too few data field" message and not let
me use mail merge - I would still like to fix this problems - I have
several table and a few querys that I would completely have to redo to
make this work correnctly (without the spaces)

does any of this make any sense?

Thanks
Keith

 

[Doug Robbins - Word MVP]

If you have a field in the Access query with the name Client Name as two
words, Word is seeing that as two fields when in fact the data for is
containined in just one field.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Peter Jamieson]

Can you post the SQL version of the query here please?

Peter Jamieson