Re: Automatic numbering of members with a letter
- From: "Céline Brien" <celinebrien@xxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 14:17:48 -0400
Hi everybody,
Hi Karl,
Thank you for your answer.
That is a wonderful suggestion.
I will use Office P and Office A
Whenever necessary, I wil put the two fields together and obtain the letter
and the number.
=NoMember:[Office]&" "&[MemberNo] and obtain :
P1
A1
P2
A2
etc.
Thank you so much for that idea.
Very simple to implement.
Céline
"KARL DEWEY" <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message
de news: CE0D16E2-2547-43F6-83D7-6EC392E05553@xxxxxxxxxxxxxxxx
Use a field named Office. Put 1 or 2 in the field.
--
KARL DEWEY
Build a little - Test a little
"Céline Brien" wrote:
Hi everybody,
Already have a DB with members in Office 1.
We are opening a new office. Office 2 will have it's own DB.
Using link tables and union queries, the members of Office 1 and Office 2
find themselves in the same list.
To tell apart members of Office 1 from members of Office 2, in the DB of
Office 2 I create a autonumber field with the following format : \A00000
Everything looks fine, BUT, when I put the two list together with a Union
Query, the letter A goes away. I can't tell apart members from Office 1
to
members from Office 2.
What should I do ?
Your help will be greatly appreciate,
Céline
.
- References:
- Automatic numbering of members with a letter
- From: Céline Brien
- Automatic numbering of members with a letter
- Prev by Date: Automatic numbering of members with a letter
- Next by Date: Re: Help writing multi select list box selections to table
- Previous by thread: Automatic numbering of members with a letter
- Next by thread: Re: Help writing multi select list box selections to table
- Index(es):
Relevant Pages
|
