Hi Team. First time poster here who is dreadful with SQL. Apologies in advance if I do not explain or lay this out correctly.
TIA for any help you can throw my way.
Although, I get a result! It's not the result I'm after.
This gives me two lines. (These results are purely for displaying on a Subform only)
What I really need is for the results to be grouped.
I tried this:
It gives me the same result (SQL is not my Forte).
As for the Select Queries, they're the same column structure and Criteria.
TIA for any help you can throw my way.
Although, I get a result! It's not the result I'm after.
SQL:
SELECT PickDate, txHandle, Bulk, Primary, TotalLines, PickHours, PickRate
FROM qKPI_BB
UNION SELECT PickDate, txHandle, Bulk, Primary, TotalLines, PickHours, PickRate
FROM qKPI_BT;
This gives me two lines. (These results are purely for displaying on a Subform only)
What I really need is for the results to be grouped.
I tried this:
SQL:
SELECT dtPickDate, txHandle, Bulk, Primary, TotalLines, PickHours, PickRate
FROM qKPI_BB
UNION
SELECT dtPickDate, txHandle, Bulk, Primary, TotalLines, PickHours, PickRate
FROM qKPI_BT
ORDER BY txHandle;
It gives me the same result (SQL is not my Forte).
As for the Select Queries, they're the same column structure and Criteria.
SQL:
qKPI_BB: PickDate = Forms|fBoard!dtPickDate & (txRunNo = Like "BUL*" [Not Visible]).
qKPI_BT: PickDate = Forms|fBoard!dtPickDate & (txRunNo = Like "MAS*" [Not Visible]).