Autonumber Prefixes into a Query

[Osiris]

Hello Everyone,

My issue is that I have three tables each with the field QuoteID. Each of quoteid field has its own autonumber prefix aka "AT" 0001, "BT"0001, and "CT"0001. I have successfully created a union query linking all of these tables together based on a different criteria. My problem is that in the union query the prefixes I had given to quoteid number is not showing up and I am left with 3 entries of 0001 instead of like it is above. Any help would be great.



Thanks,
Osiris

[Rod]

Hopefully you have three parts to your union query, one part for each table. If so include (I assume the term 'prefix' does not occur elsewhere)

"AT" AS Prefix

after the select on the first table

"BT" AS Prefix

after the select on the second table and so on.

Make sure this phrase is in the same position for each part.

You may also concatenate the QuoteId with the prefix if you so wish.

[Osiris]

Thanks very much Rod for your help. That is what I thought was the right thing to do. I don't know if this changes anything but say if I have a SELECT * (all) for a table where do I put the AS Prefix?

Osiris

[Rod]

Doesn't matter!

SELECT "AT" AS Prefix, * FROM Table;

or

SELECT *, "AT" AS Prefix FROM Table;

are both valid.

If you want to concatenate at the same time then use:

SELECT "AT" & QueryID AS ExtendedID FROM Table;

Have fun.

[Osiris]

Once again Rod, you are very helpful. Thanks for your advice.