list not available in Data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mairtin - 21 Nov 2006 17:42 GMT

I am using mail merge to merge a word letter with a table in Access. I
select the data source and want to filter some records. When I select the
dropdown list the option all. blanks etc are there. Sometimes I get a listing
of teh individual data that is in the record and sometimes not. for example
one colume has post code and I have only 3 different codes repeated many
times. They dont appear for some reason. I have checked to make sure teh
reckords are not filtered in Access and checked teh data types etc. Just
cant explain why it works in some data sources and not in others. Any ideas
folks???

Reply to this Message

Mairtin - 21 Nov 2006 23:38 GMT

Perhaps I can explain that a little clearer

I have an access database as a data source, when I try to filter the data by
using the dropdown list on the header row of the data source it sometimes
gives me the data that is in the fileld. ie I have one column of data for
post code. There are four possible codes and I can select any one and it
filters the records according to the selected code. However I dont always
get this listing!!! I can go into advanced and filter it in there but why do
I get thelisting for some fields and not for others????

> I am using mail merge to merge a word letter with a table in Access. I
> select the data source and want to filter some records. When I select the
[quoted text clipped - 5 lines]
> cant explain why it works in some data sources and not in others. Any ideas
> folks???

Reply to this Message

Doug Robbins - Word MVP - 22 Nov 2006 04:23 GMT

I would always use the database application to manipulate data; not a word
processor.

Signature

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

> Perhaps I can explain that a little clearer
>
[quoted text clipped - 21 lines]
>> ideas
>> folks???

Reply to this Message

Mairtin - 22 Nov 2006 19:43 GMT

thanks Doug I would agree only that i am an It trainer and have to explain
this to students. My colleagues are also puzzled and they are all MOS
Masters!!! I would use the advanced filtering options but it just puzzles
me!!! Any ideas???

> I would always use the database application to manipulate data; not a word
> processor.
[quoted text clipped - 24 lines]
> >> ideas
> >> folks???

Reply to this Message

Peter Jamieson - 29 Nov 2006 22:30 GMT

I /think/ the essence of it is that if there are 1 to 10 different values in
the list, Word will display the values in the drop-down and let the user
select one of them. If there are 11 or more values, Word doesn't display any
of them. It doesn't display the 10 most frequent ones; it just doesn't
display any of them. It could well be more complicated than that, but that's
what a quick look suggests.

MOS Masters?

Peter Jamieson

> thanks Doug I would agree only that i am an It trainer and have to explain
> this to students. My colleagues are also puzzled and they are all MOS
[quoted text clipped - 40 lines]
>> >> ideas
>> >> folks???

Reply to this Message

Rate this thread: