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