This is my first attempt at using a Union Query - Any help would be greatly appreciated!
I have 5 fields I'm combining from two tables:
SELECT [AcctNumber],[ReqNumber],[ReqDate],[Description1],[SupplierName]
FROM [tblRequisitions]
UNION SELECT...
Hi everybody,
I've fairly new to access and don't have a CLUE where to begin with this - I'm more than willing to do some research but I don't even know what to look for.
I have a tblOrders; tblAccounts
In my form I have a combobox to select the "account" number assigned to the order. Each...
I have a form called NewRequisitions that had a combobox in which the users select the Supplier (name, address, shipping details). I created a button to open a subform called NewSupplier so that they can add a new supplier to the Supplier table as needed. My code works okay for the first...