Actually,

You did a great job with the specs. I am only lost in two areas of your specs.

(************************ Part 1 Beginning Here ***************************)

My data should be like this
Task ID : 1
- Sub Task ID : 1
- Sub Task ID : 2
- Sub Task ID : 3
- Sub Task ID : 4
Task ID : 2
- Sub Task ID : 1
- Sub Task ID : 2
- Sub Task ID : 3
So when I go to add a Sub Task to Task 1, the new Sub Task ID should be 5.
And when I go to add a Sub Task to Task 2, the new Sub Task ID should be 4.

(**************************** Part 1 Ending Here********************************)

Mr smiley2004_10 <cas23121964@gmail.com>

I think the Part 1 as I have identified above and I think clearly to all who view your PDF.
You should simply delete. Get rid of it entirely. It is not a spec. It is an excel users visibility problem.
What I mean is you now have a much more enterprise worthy tool you are maybe
writing your first application with this tool (MS Access Development).

You have done an outstanding job with your drop down lists your referencing in the Screen layout
Grids, and those tables you created perhaps using word or maybe excel with highlighting are great.
I totally understand them.

Now per my comment that its an excel users visibility problem. What I mean is that the majority
of people like viewing task numbers so perfectly formed and number as you show on what I
view as some crazy wish list. You do not need to have those numbered in that manner at all.
You are using a database tool and creating forms using the MS Access forms designer.
You are suppose to hide data. Since that is true. Who cares if a perceived task 1 is under the
hood actually maybe say NUMERIC VALUE 20 - no one in the world needs to know or care just as long
as those numbers tie lets say JOIN (DATABASE TERMINOLOGY) your parent table to its sub/child table.

Your users will never see these values. You are breaking away from visual cues that need to please
human beings or they will fall apart, lack confidence etc... You need to keep those people away from
the glue that JOINS your tables together. Simple auto-number values performed sequentially
are going to do the job. Keep those foxes out of the chicken house as you are now the man the one
who in the future will fix repair any program or system failures which I doubt will ever occur.

You are treating a great tool as if it must reveal all to the users. You broke that contract
when you chose a real tool that encourages even vilifies such a need.
You now have your own deal your own glue (your table design) holding the relationships
of you
r tables together. Please do not try to please those people who want to remain
using excel. You are making way to much effort on making the database provide
some non-existing need to visually please those who do not understand that they need not
know any of those links the exact numbers ever again. Its now entered the abyss
of them needing to do absolutely nothing not ever needing to see values that add nothing to the
desired end result except that they if ever seen would look really great and orderly.
The relational model provides that glue. Never ever reveal the glue. Tell them to stay in their lane.
The design of your tables is in my view par-ex-cell-lent NOT TRYING TO BE EXCEL a more visible tool.
You can certainly hide things in excel too and some designers should probably do so in that tool as well.

The only other disconnect that I had was you did not define what the p or the m of "p/m" means.
Also the entire excel sheet of values you purport to have meaning is unclear to me as why did you not provide
headers and row numbers. Then using those coordinates describe any calculated results perhaps even using
excel references/calculations even. I could probably understand some writing that you could also provide
mentioning Column E row 12 containing excel like calc B12*1.5(result of Drop down selection from table/list xyz)
You could probably dial us all in on the Highlighted resultant fields (proposed output) of what will be
a micro-soft forms output or maybe a MS Access Report. I have no idea your intended output since you gave us
all an excel sheet with no headers no row numbers/anchoring values how could anyone follow that?

If you tag on column headers and row identity of some sort and just give proposed calculations we could probably
follow you to a conclusion and likely understand an intended programmed result.

Your 95% done just some tweaking and we all slide into home plate.

Excellent clean specs. Please delete unnecessary work items to please those who don't want you to use MS Access.
Give anchoring headings for rows columns and present calculations using co-ordinates to describe proposed
results. Slide us all into home plate...

Regards,

Mark A Stacklin

On Sunday, December 13, 2020, 06:44:14 PM EST, smiley2004_10 <cas23121964@gmail.com> wrote:

I would like to achieve the following on a form view and the ability to calculate each sub row task.

As can be shown I have also given the table structure and input and out put. The calculation starts a $50

Is this possible using Access and SQl

My data should be like this
Task ID : 1
- Sub Task ID : 1
- Sub Task ID : 2
- Sub Task ID : 3
- Sub Task ID : 4

Task ID : 2
- Sub Task ID : 1
- Sub Task ID : 2
- Sub Task ID : 3

So when I go to add a Sub Task to Task 1, the new Sub Task ID should be 5.

And when I go to add a Sub Task to Task 2, the new Sub Task ID should be 4.

Input screen form - please find uploaded

Output – as stated the calculation starts at $50 if the price is above the clients tolerance of $432p/m in this case yes the value based price is $855.36 p/m

It is then added to the final price structure before options are added or behaviour values and discounts

Tables

Questions

Question	Answer Type	Value Type	Yes Value	No Value	Default Value	Dropdown list or Unit price question
About your business
What is your annual sales?	Dropdown	Value				Annual accounts turnover value (FEB)
What type of business do you have?	Dropdown	Multiplier				Annual accounts business type multiplier (FEB)
What is your trading entity?	Dropdown	Multiplier				Annual accounts trading entity multiplier (FEB)
How many owners are there?	Value	Unit Price
Are you registered for sales tax (VAT/GST)?	Yes or No	Percentage Increase	10	0	Yes value
About your accounting system
What accounting system do you have?	Dropdown	Multiplier				Annual accounts accounting system multiplier (FEB)
Do you have a fully balanced trial balance?	Yes or No	Percentage Increase	30	0	Yes value
Do all your bank accounts reconcile?	Yes or No	Percentage Increase	-20	0	Yes value
Do you have personal out of pocket expenses?	Yes or No	Percentage Increase	5	0	Yes value
Do you have a payroll scheme?	Yes or No	Percentage Increase	10	0	Yes value
Do you have inter-company accounts?	Yes or No	Percentage Increase	10	0	Yes value
Do you have overseas sales?	Yes or No	Percentage Increase	5	0	Yes value
What is the quality of your records?	Dropdown	Percentage Increase				Annual accounts quality of records percentage (FEB)
About the service you want
Do you want our 30-day FastTrack service?	Yes or No	Percentage Increase	10	0	Yes value
How many earlier years' accounts do you need?	Dropdown	Percentage Increase				Annual accounts earlier years accounts percentage (FEB)
Who would you like to be assigned to?	Dropdown	Multiplier				Annual accounts seniority of accountant multiplier (FEB)

What follows are the lists created for each of the Dropdown questions.

Lists

Annual accounts turnover value (FEB)

1 - 80,000	840
80,001 - 150,000	1440
150,001 - 500,000	2100
500,001 - 1,000,000	3000
1,000,001 - 2,000,000	4200
2,000,001 - 5,000,000	6900
5m+	10200

Annual accounts business type multiplier (FEB)

Manufacturing	1
Bars, cafes and restaurants	1.2
Retail	1.1
Construction	1.2
Professional service business	1
Property dealer	0.8
Other	1

Annual accounts trading entity multiplier (FEB)

Sole trader	1
Partnership	1.2
Limited Liability Partnership	1.2
Limited Company	1.2
Other (including Limited by Guarantee)	1.2

Annual accounts accounting system multiplier (FEB)

QuickBooks Online	0.8
Manual	1.5
Excel spreadsheet	1.2
Desktop accounting system	1.1
Xero	0.9
Other cloud accounting system	1

Annual accounts quality of records percentage (FEB)

Poor	50
Average	0
Excellent	-10

Annual accounts earlier years accounts percentage (FEB)

Not applicable	0
1 year	80
2 year	150

Annual accounts seniority of accountant multiplier (FEB)

Partner	1
Senior manager	0.75

Expressing Price

Suggested settings are:

Minimum price: 1000

Maximum price: 50000

Price descriptor: Your small monthly investment is just…

Pricing of packages

Description	Adjustment Type	Price Adjustment	Rounding On	Rounding Amount	Period Spread Over
Lite	Relative	0.75	OFF		12
Entry Accounting	Relative	1	ON	9	12
Full Accounting	Relative	1.3	ON	7	12
Advanced Accounting	Relative	1.5	ON	9	12

Rewards

Question	Value Type	Yes Value	Default Value
Behaviour rewards
Manual/Excel: Will you provide a balanced trial balance?	Percentage decrease	20	No value
Do you want us to do the bookkeeping?	Percentage decrease	30	No value
Get a 15% discount when you pay us in full in advance	Percentage decrease	15	No value
Will you refer us to 3 other businesses like yours?	Fixed discount	500	No value

Options

Question	Description	Value Type	Yes Value	Default Value
Optional extra services
Annual 5-year trend analysis report	Only $17 per month when added on to your annual accounts	Value	200	No value
Audit		Percentage increase	20	No value
Cash reconciliation report	Only $42 per month when added on to your annual accounts	Value	500	No value
Goal review meeting	Only $42 per month when added on to your annual accounts	Value	500	No value
PAYE/NIC and VAT health checks	Only $83 per month when added on to your annual accounts	Value	1000	No value
Preparation of sales tax returns	Only $83 per month when added on to your annual accounts	Value	1000	No value
Pre-year end tax planning review	Only $42 per month when added on to your annual accounts	Value	500	No value
Profit improvement planning meeting	Only $42 per month when added on to your annual accounts	Value	500	No value
Quarterly business strategy meetings	Only $167 per month when added on to your annual accounts	Value	2000	No value

Adrian

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.