RE: [MS_AccessPros] New project - I will need some help I'm sure

 

Hi Nige

 

Feel free to upload a sample database with your empty tables if you want. I'm sure lots of members are ready and able to help when you need it.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, March 14, 2018 6:41 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] New project - I will need some help I'm sure

 

 

Hi all,

It's been several years since I've been here! I have a new project - so just warning you very helpful people that I'm sure I will need some assistance as some of what I want to do will be beyond my Access ability!!

A quick summary - I need to create an application to import phone billing data and produce summaries for customer invoicing. The db will holds customer information, including 1 or several phone numbers, and a list of services with uplift percentages, and a list of specific items with prices. I need to be able to import data from txt files into tables (I think 2 tables as there are 2 types of data), then specify from/to dates, match customers against their billing data (the relevant imported billing rows will be matched against the phone numbers held in the customer records), then the relevant percentages from the customer records applied to the imported cost prices, or fixed prices applied where these exist in the customer record. I'll need to run reports for specific customer/s between from/to dates to list all the data to be invoiced in that period, for finance to then use to create invoices in the accounts system.

Hope this makes some sense - it's clear in my mind as I've been using spreadsheets and pivot tables to extract data for a few months, but that's driving me mad and becoming unwieldy as customer numbers and data to bill increase.

 

Nige

__._,_.___

---

Posted by: "Bill Mosca" <wrmosca@comcast.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___