jrsaturnino
New member
- Local time
- Today, 10:33
- Joined
- Jun 21, 2019
- Messages
- 9
Good morning smart people!
I hope one of you can help my current issues that i am facing with MS Access.
The situation is i made separate tables for Customers, Sales and Collection. Then when i created a query from those tables i got duplicated results. I was expecting by obtaining the information from those tables will give me the following:
1. Sales table will match payments from collection table using the reference number.
2. No duplicates
3. Customers, Sales and Collection Tables will merge into one report on a query.
Hope you can help me with this. I am not a programmer just a newbie in MS Access. Still Learning!.
Thanks,
Bert
I hope one of you can help my current issues that i am facing with MS Access.
The situation is i made separate tables for Customers, Sales and Collection. Then when i created a query from those tables i got duplicated results. I was expecting by obtaining the information from those tables will give me the following:
1. Sales table will match payments from collection table using the reference number.
2. No duplicates
3. Customers, Sales and Collection Tables will merge into one report on a query.
Hope you can help me with this. I am not a programmer just a newbie in MS Access. Still Learning!.
Thanks,
Bert