I have a query that looks like:
Acct#,Name,Loc,Utility Type.
123,Diane,3008 Look up St,W(Water)
456,Juli,4407 Pleasant St, W(Water)
456,Juli,4407 Pleasant St, S(Sewer)
From the data above you will see I have one record with Water...
I need a yes or no field showing the record does not have Sewer account with it.
All records should have both Water and Sewer...but some don't have Sewer.
How can I run a query and just show the Water without Sewer accounts??
I need them to cross reference to one another...
Can you please help??
Thanks
ddbrook
Acct#,Name,Loc,Utility Type.
123,Diane,3008 Look up St,W(Water)
456,Juli,4407 Pleasant St, W(Water)
456,Juli,4407 Pleasant St, S(Sewer)
From the data above you will see I have one record with Water...
I need a yes or no field showing the record does not have Sewer account with it.
All records should have both Water and Sewer...but some don't have Sewer.
How can I run a query and just show the Water without Sewer accounts??
I need them to cross reference to one another...
Can you please help??
Thanks
ddbrook