AndrewCorkery
Technical User
Hi,
I have the following data and need to return just the one record for 2 fields and if it does have a duplicate still return the record but have a zero value in the numeric field.
Company Field1 Field2 Field3 Field4
A 12 121 122 232
B 11 144 431 332
C 10 101 182 543
A 12 132 552 987
B 14 119 212 432
As you can see there is a duplicate for Company A in Field1. How can I return a 0 in Field1 if a company already has that value? This needs to be done in a query.
Thanks
Andrew
I have the following data and need to return just the one record for 2 fields and if it does have a duplicate still return the record but have a zero value in the numeric field.
Company Field1 Field2 Field3 Field4
A 12 121 122 232
B 11 144 431 332
C 10 101 182 543
A 12 132 552 987
B 14 119 212 432
As you can see there is a duplicate for Company A in Field1. How can I return a 0 in Field1 if a company already has that value? This needs to be done in a query.
Thanks
Andrew