|
|
I have a contact database with a multi-value field for signers of
correspondence (multiple people can sign a single letter). I would like to
group contact lists by the multi-value field without getting a line for each
signer. For example, if the value of the multi-value field was "Smith,
Jones" I'd like the contact to be shown on only one line of the list with
"Smith, Jones" as the group. Can this be done.
Any help would be greatly appreciated
|
|
Jon
It is possible (not a good idea but possible) to store more than one fact in
a field. When you say "a multi-value field", what comes to mind is a series
of values, separated by, oh, I don't know, commas?<g>
Which version of Access are you using?
More info, please...
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Jon" <Jon[ at ]discussions.microsoft.com> wrote in message
news:6948ADDE-20C4-43D9-8E8D-914DFB039F59[ at ]microsoft.com...
[Quoted Text] >I have a contact database with a multi-value field for signers of
> correspondence (multiple people can sign a single letter). I would like to
> group contact lists by the multi-value field without getting a line for
> each
> signer. For example, if the value of the multi-value field was "Smith,
> Jones" I'd like the contact to be shown on only one line of the list with
> "Smith, Jones" as the group. Can this be done.
>
> Any help would be greatly appreciated
|
|
Jeff,
It's gotta be 2007.
I cannot believe that Microsoft added a multi-value field data type in 2007.
I think it was to achieve compatibility with Sharepoint, but this is just
the next logical step in the misguided "lookup" field experiment.
If you select "lookup wizard" as the datatype when creating a new field, you
can enter select to manually enter values in a column or use an existing
table for your lookup. If you manually create the list of values, Access
hides the lookup table from the user. Either way, on the last page of the
wizard, there is a checkbox that lets you Allow Multiple Values. If you
check this, you now have a multi-value field.
If you save the table, then open it and click in that field, you will see
your options, with checkboxes next to them. If you check the items and then
move to another field, you will see the values you selected, separted by
commas.
--
HTH
Dale
email address is invalid
Please reply to newsgroup only.
"Jeff Boyce" wrote:
[Quoted Text] > Jon
>
> It is possible (not a good idea but possible) to store more than one fact in
> a field. When you say "a multi-value field", what comes to mind is a series
> of values, separated by, oh, I don't know, commas?<g>
>
> Which version of Access are you using?
>
> More info, please...
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
>
> "Jon" <Jon[ at ]discussions.microsoft.com> wrote in message
> news:6948ADDE-20C4-43D9-8E8D-914DFB039F59[ at ]microsoft.com...
> >I have a contact database with a multi-value field for signers of
> > correspondence (multiple people can sign a single letter). I would like to
> > group contact lists by the multi-value field without getting a line for
> > each
> > signer. For example, if the value of the multi-value field was "Smith,
> > Jones" I'd like the contact to be shown on only one line of the list with
> > "Smith, Jones" as the group. Can this be done.
> >
> > Any help would be greatly appreciated
>
>
>
|
|
It's 2007.
"Jeff Boyce" wrote:
[Quoted Text] > Jon
>
> It is possible (not a good idea but possible) to store more than one fact in
> a field. When you say "a multi-value field", what comes to mind is a series
> of values, separated by, oh, I don't know, commas?<g>
>
> Which version of Access are you using?
>
> More info, please...
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
>
> "Jon" <Jon[ at ]discussions.microsoft.com> wrote in message
> news:6948ADDE-20C4-43D9-8E8D-914DFB039F59[ at ]microsoft.com...
> >I have a contact database with a multi-value field for signers of
> > correspondence (multiple people can sign a single letter). I would like to
> > group contact lists by the multi-value field without getting a line for
> > each
> > signer. For example, if the value of the multi-value field was "Smith,
> > Jones" I'd like the contact to be shown on only one line of the list with
> > "Smith, Jones" as the group. Can this be done.
> >
> > Any help would be greatly appreciated
>
>
>
|
|
Dale
(that was my assumption, too, but just in case...)
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Dale Fye" <dale.fye[ at ]nospam.com> wrote in message
news:89B37B2E-F0EC-4B0C-8504-64F4AB82FC39[ at ]microsoft.com...
[Quoted Text] > Jeff,
>
> It's gotta be 2007.
>
> I cannot believe that Microsoft added a multi-value field data type in
> 2007.
> I think it was to achieve compatibility with Sharepoint, but this is just
> the next logical step in the misguided "lookup" field experiment.
>
> If you select "lookup wizard" as the datatype when creating a new field,
> you
> can enter select to manually enter values in a column or use an existing
> table for your lookup. If you manually create the list of values, Access
> hides the lookup table from the user. Either way, on the last page of the
> wizard, there is a checkbox that lets you Allow Multiple Values. If you
> check this, you now have a multi-value field.
>
> If you save the table, then open it and click in that field, you will see
> your options, with checkboxes next to them. If you check the items and
> then
> move to another field, you will see the values you selected, separted by
> commas.
>
> --
> HTH
> Dale
>
> email address is invalid
> Please reply to newsgroup only.
>
>
>
> "Jeff Boyce" wrote:
>
>> Jon
>>
>> It is possible (not a good idea but possible) to store more than one fact
>> in
>> a field. When you say "a multi-value field", what comes to mind is a
>> series
>> of values, separated by, oh, I don't know, commas?<g>
>>
>> Which version of Access are you using?
>>
>> More info, please...
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>>
>> "Jon" <Jon[ at ]discussions.microsoft.com> wrote in message
>> news:6948ADDE-20C4-43D9-8E8D-914DFB039F59[ at ]microsoft.com...
>> >I have a contact database with a multi-value field for signers of
>> > correspondence (multiple people can sign a single letter). I would like
>> > to
>> > group contact lists by the multi-value field without getting a line for
>> > each
>> > signer. For example, if the value of the multi-value field was "Smith,
>> > Jones" I'd like the contact to be shown on only one line of the list
>> > with
>> > "Smith, Jones" as the group. Can this be done.
>> >
>> > Any help would be greatly appreciated
>>
>>
>>
|
|
|