I have a table (VWTbl). In this table there is an Order_No field and a Claim_type field (amongst others). I want to create a query that only shows order numbers where more than one claim type has been applied. In this instance claim types would be SRC & 4C.
So a query that outputs the order number only when claim types src and 4c have been both applied to the same order number.
Last edited by p0508; 05-20-09 at 01:27.
Reason: try to make the question easier to understand
How do you determine that more than one claim have been applied for one order? Do you have several Claim column in the table or do you put the different claims (I suppose that SRC and 4C are claim codes), such as SRC, 4C or SRC4C or any other kind of combination? I also suppose (and hope!) that there is only one row per Order_No.
Could you please supply more explanations about your data model?