Hi Folks,
I've built a simple search form that allows end users to input a value in a form, e.g. in a textbox. A query then uses this parameter as a criteria. I have no problem doing this in QBE but lately, I am trying to use a UNION query and the SQL is way over my head.
Please read the following before looking at the attachment:
1) I have two tables on which I am trying (and failing) to use a UNION query to pull the two datasets together... see tblINVOICE and tblINVOICE-ARCHIVE.
2) Open frmSearch and see that the Invoices shown are only coming from tblInvoice.
3) I am trying to get invoice records from both tblInvoice and tblInvoiceArchive to appear in the search results. I have deleted my previous Union Query Attempts!
4) Finally, please note that i am using the following parameters as criteria:
Between [START Date] and [END Date] ( and check box [Paid])
Please help if you can,
much appreciated,
Tiny