İptal Edildi

Design / Teach MS Access that has dynamic changable formulas

I have a database I have designed so far, which is essentially a Laboratory database which lets users enter new tests, which consist of various analytes. The user can group all these analytes into a test, and through a client window they can enter new samples, and pick the tests each sample will have (may be multiple) then in the results page I need help, what I want to be able to happen is for a table to be generated that allows for the results to be entered based on the test that was selected.

In addition to this, in the Sample table, I have a field called parentsample, which allows a child sample to be generated to a parent sample. I would like to get some help to be able to show all calculations of child samples, as a report below the parent sample.

The Main part through, is allowing the database to have the ability to get a user to enter a query in the test, which will be able to be changed for each different test regardless of how many tests there are. What I mean by that is that say for example i have test A, which consists of Time, Weight, Analyte Result, and Surface area. In each test, I enter the forumula and whenever the report is generated, it checks the test to see the query, runs the query which fetches all the individual results, and performs that report. The important this is that one test might do that, but another test might have just Volatile Content, Moisture, Time, Temperature and would need to preform a different calculation on different data which is all contained within the one table (results which contains ResultID, SampleID, Test Name, Test Result, Test Units )

The trick is to allow users to enter it in the test settings table, instead of having to recreate the table each time again and again which is just not really practical.

For example the main test might have a parent product, which has surface area, and child products that contain results, air flow, and units, so it would also need to be able to query child and parent samples to find the appropiate value, but this would normally be a set value, i.e it always happens that there are four child products which need to query the pearent products surface area.

Need help!, Table is half designed but need help with low budget to work out the other part with modifiable calculations etc.

Beceriler: Microsoft Access, SQL

Daha fazlasını görün: window design group, user tests, product table design, products database design, product database design, part time product design, name flow, want design products, get product design, find flow, flow design, design table, design checks, air products, access group, test formulas access, access formulas, sql client, microsoft access test, product design part time, trick, temperature, surface design, report design, has

İşveren Hakkında:
( 33 değerlendirme ) Beaconsfield Upper, Australia

Proje NO: #748893

22 freelancer bu iş için ortalamada 123$ teklif veriyor

HussienSharaf

HI, I m the best MS Access, I m professional in creating dynamic SQL and dynamic coding. Plz check PM. Regards, Hussien Sharaf

in 2 gün içinde70$ USD
(34 Değerlendirme)
6.8
fedalal2

Hi, I have more 10 years in MS Access (SQL server) I can make it fast. Alex

1 gün içinde 100$ USD
(15 Değerlendirme)
4.8
frehmanpk

Respected Sir, Please see PM for details. Kindest Regards.

in 0 gün içinde30$ USD
(15 Değerlendirme)
4.5
SmartGuru

Hello, Using VBA, the solution for dynamic formulas can be provided to you. I would be glad to help you realizing your project. Regards.

in 3 gün içinde90$ USD
(7 Değerlendirme)
4.0
ssivanov

I can help you. Contact me via PMB. I have over 10 years experience in MS Access.

in 10 gün içinde240$ USD
(0 Değerlendirme)
0.0
falakawan

understood your requirements and will deliver desired product within time and budget being a professional of this field since long

in 5 gün içinde200$ USD
(0 Değerlendirme)
0.0
ayep

Hi, I'm interested with your job. I'm an expert in database management system and software development. I've done many projects related to it. With regard to your project, I suggest to build a software (with the data Daha fazlası

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
kaddusgfl01

Hello, I’ve 15 years experience in the computer jobs. My academic background is master in statistics. I have got OCA, MCP. I’m interested to do online works.

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
JAGADEESANMUDU

I CAN PROVIDE SOLUTION FOR YOUR REQUIREMENT

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
yoctoclub

I can do that easily.

in 20 gün içinde100$ USD
(0 Değerlendirme)
0.0
kalneel143

Hello , i m working as a software developer in a company and have experience of professional databases. will give u a better option for ur database. I am very interested in developing this project as the skills and th Daha fazlası

in 9 gün içinde170$ USD
(0 Değerlendirme)
0.0
sisinuk

Hi there, i am a database programmer and consultant and happy and absolutely keen to deliver you the solution. regards

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
asonua

Hi, I am Database Designer. Please give me oppertunity.

in 7 gün içinde200$ USD
(0 Değerlendirme)
0.0
progrish

I am computer database programmer in a very big company (sales,production,human resources,accounting). I work on SQL Server, .NET, C#, Asp.Net, MS Access (business application). I can do this job. Thank you.

in 8 gün içinde200$ USD
(0 Değerlendirme)
0.0
alainalexa

I am very interested in developing this project as the skills and the knowledge needed are matching with my area of expertise.

in 5 gün içinde200$ USD
(0 Değerlendirme)
0.0
grzegorz7bylica

Hi. I have three years experience as a developer. Price shows that, just starting to freelancer.

in 14 gün içinde30$ USD
(0 Değerlendirme)
0.0
privani

Please check my PM. Thank you

in 7 gün içinde150$ USD
(0 Değerlendirme)
0.0
elhachem

I am un expert in Access

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
Gil95

Hello check pmb

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
billfan88

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Daha fazlası

in 2 gün içinde200$ USD
(0 Değerlendirme)
0.0