I am creating a database to help with some of my financial and accounting responsibilities. I am most certainly a novice at access so any help you can provide will be appreciated.
This database will be used once a month and the source transnational data will be replaced each time.
In the database I will be keeping a customer table which will not be replaced, but I will need to append it based off of the new transaction data. I will be adding all new unique customerIDs to the customer table along with their associated customer names.
I wrote the code below to come up with the list of unique customer ID's in the transaction table. It does appear to return a list of unique customerIDs but I want to clarify if that is indeed what it is doing.
Is the code actually returning all unique customerIDs and their associated names?
Is it returning all unique combinations of CustomerID and CustomerName?
Is it returning all unique customerIDs and unique customer names?
I know that a customer's name does sometime change, but in reality I am not concerned with these changes because even if the name changes, the entity that name represents stays the same (Think someone changing their name after they get married i.e. the customerID will never be used for an actual different customer). I just want to make sure that I have an list of unique customerIDs only. The customer Name should only be a descriptive field for the CustomerID.
The next step is to use this list and append my customer list. Is the code above even taking me in the right direction to achieving this goal?
Thanks for your help.
This database will be used once a month and the source transnational data will be replaced each time.
In the database I will be keeping a customer table which will not be replaced, but I will need to append it based off of the new transaction data. I will be adding all new unique customerIDs to the customer table along with their associated customer names.
I wrote the code below to come up with the list of unique customer ID's in the transaction table. It does appear to return a list of unique customerIDs but I want to clarify if that is indeed what it is doing.
Code:
SELECT DISTINCT tbl_PRODetail.[Customer ID], tbl_PRODetail.[Customer Name]FROM tbl_PRODetail;
Is the code actually returning all unique customerIDs and their associated names?
Is it returning all unique combinations of CustomerID and CustomerName?
Is it returning all unique customerIDs and unique customer names?
I know that a customer's name does sometime change, but in reality I am not concerned with these changes because even if the name changes, the entity that name represents stays the same (Think someone changing their name after they get married i.e. the customerID will never be used for an actual different customer). I just want to make sure that I have an list of unique customerIDs only. The customer Name should only be a descriptive field for the CustomerID.
The next step is to use this list and append my customer list. Is the code above even taking me in the right direction to achieving this goal?
Thanks for your help.