Hi Im using Access 2003. I need to bring two tables together to
generate a report 1 is from a maintenance assets database and 1 is
from a maintenance general repair/jobs database. Both have their own
respective ID fields set to autonumber. On the jobs side I just have
a job description but on the other I have asset groups with its
description and ID and hanging from that a breakdown of the tasks that
apply to the maintenance of that asset. With help Ive now got a Union
qry bringing the two tables together but I am at present running the
risk of duplicating the ID field. Ive tried applying a custom format
to the ID table but although I can add as many zeros or put a 1 and
zeros in front the underlying number still seems to just to continue
to count from 1 upwards. Am I able to change this.

Thanks in advance for any help.

DonH

On Tue, 31 Aug 2010 06:21:25 -0700 (PDT), don <(E-Mail Removed)> wrote:

>Hi Im using Access 2003. I need to bring two tables together to
>generate a report 1 is from a maintenance assets database and 1 is
>from a maintenance general repair/jobs database. Both have their own
>respective ID fields set to autonumber. On the jobs side I just have
>a job description but on the other I have asset groups with its
>description and ID and hanging from that a breakdown of the tasks that
>apply to the maintenance of that asset. With help Ive now got a Union
>qry bringing the two tables together but I am at present running the
>risk of duplicating the ID field. Ive tried applying a custom format
>to the ID table but although I can add as many zeros or put a 1 and
>zeros in front the underlying number still seems to just to continue
>to count from 1 upwards. Am I able to change this.
>
>Thanks in advance for any help.
>
>DonH

If it's just for a report, why include either Autonumber in the query at all?
An autonumber has only one purpose: to define a meaningless unique key for a
table, to be used (under the covers and out of view) for linking to other
tables. If you're assigning meaning to the value you probably should not be
using an Autonumber for it at all!

Please explain how the autonumber value is being used in this UNION query, and
how you expect it to be duplicated (or, more accurately, how the already
existing duplications might be exposed).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com