Hi guys,
I know I have done some research on this before and I was advised it was not best database practice.
However, I have a form that calculates a profit field. It has stored values from tables in my db that do a series of calculations on the form, and the profit box displays the profit for the particular job.
My total expenses figure is something similar, it is a calculated field comprising of many expenses, which is then deducted from the capital to leave the profit.
My question is this, if I have 20 jobs, I want to view all profits for each job in one query (or store the profit figure in a table for analysis?), I would just like to compare and contrast profit numbers against one another in access, without having to revert back to excel. I am sure this can be done.
All help will be greatly appreciated
Best,
Michael
I know I have done some research on this before and I was advised it was not best database practice.
However, I have a form that calculates a profit field. It has stored values from tables in my db that do a series of calculations on the form, and the profit box displays the profit for the particular job.
My total expenses figure is something similar, it is a calculated field comprising of many expenses, which is then deducted from the capital to leave the profit.
My question is this, if I have 20 jobs, I want to view all profits for each job in one query (or store the profit figure in a table for analysis?), I would just like to compare and contrast profit numbers against one another in access, without having to revert back to excel. I am sure this can be done.
All help will be greatly appreciated
Best,
Michael