Hi All
I have sets of records that all have a reference number and a status that i would like to query as follows:
For example:
This would show 1 line for M00158 with a consolidated status of No as not all the records statuses are Yes
This would show 1 line for HLBU9503742 with a consolidated status of Yes as they are all Yes
So basically if any record has a field with No the summary will be No, otherwise it will be Yes
I know this almost certainly a very simple thing to do but i'm not having a good day so unable to think it through so would appreciate just a little bit of help nudging me in the right direction.
The sql for the query i've got so far is:
And i'm sure its a matter of just modifying it slightly and i'll feel a little bit of a fool when i see it but just can't see what to do at the moment
thanks in advance
Glen
I have sets of records that all have a reference number and a status that i would like to query as follows:
For example:
This would show 1 line for M00158 with a consolidated status of No as not all the records statuses are Yes
This would show 1 line for HLBU9503742 with a consolidated status of Yes as they are all Yes
So basically if any record has a field with No the summary will be No, otherwise it will be Yes
I know this almost certainly a very simple thing to do but i'm not having a good day so unable to think it through so would appreciate just a little bit of help nudging me in the right direction.
The sql for the query i've got so far is:
Code:
SELECT [FACT-Consignments].cons_albaran, [FACT-DeliveryProducts].del_prod_return_received
FROM [FACT-Consignments] INNER JOIN ([FACT-Deliveries] INNER JOIN [FACT-DeliveryProducts] ON [FACT-Deliveries].del_id = [FACT-DeliveryProducts].del_prod_del_id) ON [FACT-Consignments].cons_id = [FACT-Deliveries].del_cons_id;
And i'm sure its a matter of just modifying it slightly and i'll feel a little bit of a fool when i see it but just can't see what to do at the moment
thanks in advance
Glen