In Progress

Database that generates groups of 3

i need a database written in which you can enter individuals (name, address, telephone, email, occupation, Group location and a few other fields) and run a report monthly in which it will produce a list of groups of 3 people. I should be able to run this locally on my Windows 10 laptop (or online) and produce a PDF document in which i can email monthly to all people in the groups. There are about 100 names presently and this will increase monthly. This should be SIMPLE for me to enter info and run.

There are rules below that apply.

1. Members in each group cannot be from the same occupation

2. I can add new members at any time and they will be included in the next months run

3. Members of each group should not meet with the name person twice

4. There should be one (1) group leader randomly selected for each group and that person should be highlighted or bold within each group of 3

5. There are some people in the database that may not want to participate, so there should be a check box next to their name so include them or not.

5. Depending on the number of people participating, there may be an odd number, so the last group may be 2 or 4 people.

6. at some point, I may want to "reset" the groups and start over (allowing for example people to meet again with the same people). but this will only happen every few years.

7. after i run this monthly, it should produce a PDF document that can be emailed to every group member.

Skills: Database Administration, Microsoft, Microsoft Access, MySQL, Software Architecture

See more: group by * sql, group by having oracle, group by having count, can we use having clause without aggregate functions, group by having example, having clause without group by in sql server, group by and having clause in sql, having clause without group by in sql server 2008, \ m looking to hire someone to work 3 to 4 hrs a day 7 days. I will need you to follow a training video and post on my account a, We need to build a new design for this entire page (one single page): https://www.checkthem.com/reverse-phone/ - Their current , his is a simple project. I just need some database tables designe, Re-design http://www.omnidots.com and need a new design for this., Re-design http://www.omnidots.com and need a new design for this, i have started a new job as a tour guide and i need some audio transcribing from a colleagues tour of oxford stratford upon avon, facebook groups add members software

About the Employer:
( 0 reviews ) Clinton, United States

Project ID: #14879854

Awarded to:

polarjin2017

I am from china as a specialist, good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies using C#, WPF , UWP, More

$155 USD in 3 days
(14 Reviews)
4.8

24 freelancers are bidding on average $189 for this job

Prashantskin

I will write code to create groups of 3 from your members in Microsoft access Relevant Skills and Experience I have got experience of 12 + years and 500 + projects in Microsoft access My ratings and reviews in freelan More

$155 USD in 3 days
(578 Reviews)
7.3
zu02

Tricky to code project , I'll code that via Ms Access GUI Relevant Skills and Experience ado, sql, vba Proposed Milestones $555 USD - default

$555 USD in 7 days
(40 Reviews)
6.0
tojisb059

Hi, Immediate Available, Price/time after detailed discussion [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] Let's talk in detail Relevant Skills and Experience php codeigni More

$155 USD in 3 days
(29 Reviews)
6.0
workerbee1974

My passion is building Custom Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. I have screen shot samples and more reviews More

$220 USD in 3 days
(18 Reviews)
4.9
royalcalif

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Ac More

$30 USD in 1 day
(37 Reviews)
5.1
vinaysinghh

A proposal has not yet been provided

$220 USD in 1 day
(46 Reviews)
5.4
alaeddindhahri

Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist More

$222 USD in 3 days
(41 Reviews)
5.1
ITCristRo

Hi! I am a developer who has experiences on various fields of software developing. I can surely help you, and I can deliver the final product on time and on budget. Please contact me for discussion Stay tuned, I'm st More

$222 USD in 3 days
(8 Reviews)
4.4
$250 USD in 3 days
(11 Reviews)
4.6
$300 USD in 15 days
(5 Reviews)
5.0
alexanderrubtsov

Hello. My proposal is to develop a VB.Net Windows application which will use SQLite as a database engine. Algorithm for group forming may be as simple as randomly picking a person from a list of people who satisfy th More

$150 USD in 7 days
(9 Reviews)
4.2
VangHaleena17

HI You can see also my France client e-commerce site url [url removed, login to view] and [url removed, login to view] site for my HONG KONG client. Relevant Skills and Experience I will send you More

$150 USD in 3 days
(12 Reviews)
4.4
$155 USD in 3 days
(11 Reviews)
3.8
gr8tech

I will produce an Access Database solution as required. Relevant Skills and Experience I have completed similar project with reports, exporting to PDF, printing, email, etc. I have experience in Access. Excel and VBA More

$155 USD in 3 days
(6 Reviews)
4.0
drudev

Hello. I am a web developer with 15+-year experience . I work remotely on DigitalRay company - [url removed, login to view] - LA (USA). Technical knowledges: [url removed, login to view] JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symp More

$143 USD in 3 days
(5 Reviews)
4.0
AntonBliznetc

Create DB Application Relevant Skills and Experience I am a full time programmer with 20 year exp in Russia. I have hi degree in information system in economics. Proposed Milestones $98 USD - After show complete from More

$98 USD in 5 days
(11 Reviews)
2.5
johibkhan

Possess 8 years of professional experience in software application development and worked as UI architect. I was associated companies like avaya,CGI,Pramati and yash technologies Relevant Skills and Experience SQL,MYS More

$155 USD in 3 days
(3 Reviews)
1.7
clayknot

Hello, your project seems to be fairly simple and I think a web based solution would be the best and fastest option for you. I am confident that I can help you in this, looking forward to hearing back Relevant Skills More

$133 USD in 3 days
(1 Review)
1.0
$155 USD in 3 days
(1 Review)
0.2
melko1985

I will work this on WP, so the backend is easy for you to update, you can check my experience Relevant Skills and Experience wordpress, PHP, CSS, HTML Proposed Milestones $277 USD - WP development is the total group More

$277 USD in 3 days
(0 Reviews)
0.0