Recent content by haxan786

Got it, thanks everyone for valuable inputs.

In future, I am also planning to connect my backend to PowerBI, where I will need to do DAX for all calculations from the start. That is one of the reasons for storing the calculated data.

I have many considerations but I am here for expert opinion. I have already shared the problem statement. My plans are as mentioned in the last reply. Storing data on daily basis and manually when there is a big change in formulas.

In most cases, History data will not change ever, for some reason some of the equations might change over time which I can append manually. Currently, I am only storing a single efficiency value in the hourly table, I am considering all the calculations to go in a table like the below example...

1- All the calculations are done in hourly query. Then data is filtered in Daily, Yesterday, Weekly, Monthly, Fiscal Year, and Agreement Year in 6 different queries. All the data is collected for a Daily Generation Report. This is the daily report, The left part is total calculattions based...

in below example you can see how I converted query based calculations to vba custom functions, but there are like more than 40 calculations. 'IIf(Nz([RevH1])<>"",0,IIf([NEO]+[SHORT_5_4d]<[NPCCD] And Nz([Upward Declaration])<>"",(Nz([Upward Declaration])-([NEO]))*1.5,0)) Public Function...

Calculation results are needed on daily basis, in a daily generation report where Daily, monthly, and 3 types of yearly calenders get data from hourly query. Our generation invoicing is based on hourly calculation, everything is calculated on hourly basis like, Declaration, demand, generation...

Hello Team I have designed a power plant production database in MS Access, as of now its running smoothly even after 2 years. Database is mostly doing maths for different task. Efficiency correction, Stock calculations with ASTM equations, and hourly calculation based on plant load, to speed...

just check the attached report, On the left side, you will see Daily Consumption data with Weighted Average LHV and on the right side you can see FIFO Based allocation. On ROW 6 you can see fuel is consumed from two diff batches.

yes, you are right. I was actually trying to make a proper table structure but don't know why I am confused. As I mentioned earlier, I have Tank correction data. which is more complicated to be discussed here. ( Tank Height (m) x 50.29 = Tank Volume) Fuel CV or LHV is the Heating Value of any...

I need help designing FIFO Based Stock for Diesel Tanks, There are 2 Diesel Tanks. Fuel is received via Tankers. Each tanker has a different Price and Chemical Properties. Normally 1 tank will be on Filling and the other will be In-Service. I have a Calculator to correct the received Tanker...

I finally got it. There was missing required field in the statement.

Runtime error 3134 "Syntax Error in INSERT INTO statement this error popups when inserting new record

I have unbound form with insert date into two tables [DDL Master] & [DDL Detail] on click data update is working but I am getting Runtime Error "3134" on new record on dbs.Execute (q2) Private Sub Command201_Click() Me.lblDate.Locked = False Me.Text142.Locked = False Dim...

Can you check the attached forms and guide me to design table structure.