Thall
Last Activity: Nov 6 '06, 03:50 PM
Joined: Oct 18 '06
Location: South Carolina
-
Can you do a print screen of the QBE and post it here? That might help to see how it's structured.... -
This is very similar to what you are trying to do using an Oracle table. It selects Parts based on Commodity Code = BHGEN-FG-OB whose Whs ID does not equal LAN-BH-FG as well as those whose Whs ID does not equal TAC-BH-FG.
SELECT SYSADM_PART.ID, SYSADM_PART.COM MODITY_CODE, SYSADM_PART.PRI MARY_WHS_ID
FROM SYSADM_PART
WHERE (((SYSADM_PART. COMMODITY_CODE) ="BHGEN-FG-OB") AND ((SYSADM_PART.P RIMARY_WHS_ID)< >"LAN-BH-FG"))...Leave a comment:
-
Ooops....I didn't check the parentheses
Try this one.
SELECT dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id, dbo_p21_view_in v_loc.location_ id
FROM dbo_p21_view_in v_loc
GROUP BY dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id
HAVING (((dbo_p21_view _inv_loc.primar y_supplier_id)= 11235) AND ((dbo_p21_view_ inv_loc.locatio n_id)<>10) OR((dbo_p21_vie w_inv_loc.prima ry_supplier_id) =11235)...Leave a comment:
-
Here's the entire statement using OR along with AND
SELECT dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id, dbo_p21_view_in v_loc.location_ id
FROM dbo_p21_view_in v_loc
GROUP BY dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id
HAVING (((dbo_p21_view _inv_loc.primar y_supplier_id)= 11235 ) AND ((dbo_p21_view_ inv_loc.locatio n_id)<>10 OR(((dbo_p21_vi ew_inv_loc.prim ary_supplier_id )=11235...Leave a comment:
-
Try this:
HAVING (((dbo_p21_view _inv_loc.primar y_supplier_id)= 11235 ) AND ((dbo_p21_view_ inv_loc.locatio n_id)<>10 ) OR
((dbo_p21_view_ inv_loc.primary _supplier_id)=1 1235 ) AND
(dbo_p21_view_i nv_loc.location _id)<>11821)))Leave a comment:
-
Use Filter string AND OutputTo together to create multiple reports
Hey Gurus - I've seen a few solutions to this problem, but none of which I can do without a little help. Here's the situation
The following code loops thru a sales report, using the sales rep ID as a filter so that multiple reports are created. This is now generating a PDF report, but I need to change it to RTF documents.
My question is, since I can't create an RTF using open report, is there a way to use the strFilter... -
Hi - I'm not sure if this is what you're looking for, but it's close. We link to Oracle tables through ODBC and have a query that runs and makes the connection as soon as the database opens. Here's the breakdown:
1.
Creat an SQL passthru query using something similar to this: SELECT COUNT(*) FROM PRODUCT (any public.table in oracle....the smaller the better)
Right click the top bar to get to the query properties...Leave a comment:
No activity results to display
Leave a comment: