Automatic numbering of members with a letter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


.

Relevant Pages

  • Licensing - drop in live music in smaller venues.
    ... Writing about the Licensing Act on page 9 of the latest issue of Musician, ... the in-house journal for Musicians' Union members, ...
    (uk.music.folk)
  • CAW Union accepts cuts in pay, jobs
    ... CAW Union accepts cuts in pay, ... Canadian Auto Workers members at Chrysler Group's Brampton plant near ... The approval by CAW Local 1285 comes after a vote last month by members to ... Chrysler planned to make an investment at the facility worth ...
    (rec.autos.makers.chrysler)
  • Re: wages
    ... usually even the crew members go down by rate for their gear up to nothing ... the union influence is a non issue. ... There really is no union covering sound recordists / boom swingers etc, ... unfortunately) some of whom are union members and some aren't. ...
    (rec.arts.movies.production.sound)
  • Re: IA Test
    ... There were monitored by Local 15 sound department members ... the most "union" of film locals, and now sit on the executive board with ... that is what sets the Union members apart from non union...in that the ... techniques, and authorities would go a long way to justify the claim. ...
    (rec.arts.movies.production.sound)
  • Re: OT
    ... >>Employees may go on strike whether they are union members or not. ...
    (sci.electronics.design)