Pulling Data from Crazy Tables

I am having a hard time figuring out how to correctly pull data with the way my tables are built. I have the following tables:

tblCustomerAccounts, with the field:
UtilityAccountNumber - key
CustomerDBA
etc...

tblServiceAccounts, with the fields:
UtilityAccountNumber - foreign key
ServiceAccountNumber - key
MeterNumber

tblPODID, with the fields:
UtilityAccountNumber - foreign key
PODID - key

tblPODIDMeters, with the fields:
PODID - combo key
MeterNumber - combo key

tblMeterNumber
UtilityAccountNumber - combo key
MeterNumber - combo key

I set it up like this because a Utility Account Number can be just one number with a meter, OR it can be one main number with multiple Service Accounts and one meter per service account, OR it can be one main number, with multiple POD ID's, which can have multiple meters per POD ID.

It's very confusing. And I have to use composite keys because sometimes the MeterNumber field will have the value "Unmetered", which means it's not unique.

Anyway, the user is going to want to see all the Meter Numbers in one column when running certain reports. So how can I do that in a query?

And if you have any suggestions on how to make the tables simpler, I'd welcome it. I've tried to set this up many ways and it's hard to do without violating the Normal Form rules. Thank you in advance!