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.
22 freelancers are bidding on average $123 for this job
HI, I m the best MS Access, I m professional in creating dynamic SQL and dynamic coding. Plz check PM. Regards, Hussien Sharaf
Respected Sir, Please see PM for details. Kindest Regards.
Hello, Using VBA, the solution for dynamic formulas can be provided to you. I would be glad to help you realizing your project. Regards.
I can help you. Contact me via PMB. I have over 10 years experience in MS Access.
understood your requirements and will deliver desired product within time and budget being a professional of this field since long
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 Fazla
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.
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 Fazla
Hi there, i am a database programmer and consultant and happy and absolutely keen to deliver you the solution. regards
Hi, I am Database Designer. Please give me oppertunity.
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.
I am very interested in developing this project as the skills and the knowledge needed are matching with my area of expertise.
Hi. I have three years experience as a developer. Price shows that, just starting to freelancer.
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 Fazla