Ok guys/gals, I'm just a newbie here and I'm trying to do some reading on union queries. It seems that if your trying to keep an on-hand balance of inventory that this is the most suggested. I tried doing multiple searches on anything that might relate to both these items but can't seem to find anything. So if anybody got some reference that I can do some reading on, I'll appreciate it. Thanx.