Filter in expression builder

[aliikhlaq2006]

My question is how to filter or set parameter in calculated expression builder for example i have this field calculated
Round(Nz(([SalaryData]![BasicSalary]/([SalaryData]![StandardHrs]*[SalaryData]![StandardDays]))*[SumOfOvertimeHrs],0),0)

I want to set the date parameter on the red color field how i can do this

 

[plog]

We would have to see some sample data from your underlying tables to see exactly what you wanted to achieve.

Also, you probably need to catch 0 values in your Hrs and Days fields, otherwise you could get a divide by 0 error.

 

[aliikhlaq2006]

We would have to see some sample data from your underlying tables to see exactly what you wanted to achieve.

Also, you probably need to catch 0 values in your Hrs and Days fields, otherwise you could get a divide by 0 error.

I have attached my database file please look. Goto the salary Calculation query there you will find a table OvertimeExp. This is the table where i want to set parameter to run salary every month

 

[arnelgp]

What kind of parameter is to be inputted. Please be specific.

 

[aliikhlaq2006]

What kind of parameter is to be inputted. Please be specific.

The date parameter in a calculated express builder field as i mentioned the red color

 

[arnelgp]

This calculated column is for OT Pay only, is this correct?

 

[aliikhlaq2006]

This calculated column is for OT Pay only, is this correct?

yes and i want to filter monthly

 

[arnelgp]

Please try this one

 

[aliikhlaq2006]

Please try this one

It worked for me and i have seen that you put where in the overtime query and a parameter