Hello. I have an SQL problem. Let me start by saying that I am not good at complex queries (nesting, joins, etc).
I have a table that contains order information [Orders], and a table that contains shipping information [Shipping]. I am trying to build a shipping report query that will select orders that have been shipped by comparing order numbers in each table, getting specific fields from each matched order.
First problem in the process is that in one table [Shipping] (due to bar code scanning) has a 3 digit suffix and a 2 digit prefix. The [Orders] table has neither of these. I am not sure how to have a wild card at the beginning and end of the matching portion.
Next, it would lessen the search if I could search [Shipping] by restricting it to one vendor [VendorName].
Finally, I intend to export this to a text file. I though about querying into a recordset, but I do not know if I can use a recordset name instead of a table name in the .TransferText method. If not, I would have to create a temp table with the results for the report.
As always, any assistance would be greatly aprreciated.