Filter in expression builder (1 Viewer)

A

aliikhlaq2006

Registered User.

Local time

Today, 20:10

Joined

Aug 10, 2017

Messages

17

• Aug 12, 2017

• #1

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

 

P

plog

Banishment Pending

Local time

Today, 11:10

Joined

May 11, 2011

Messages

11,635

• Aug 12, 2017

• #2

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.

 

A

aliikhlaq2006

Registered User.

Local time

Today, 20:10

Joined

Aug 10, 2017

Messages

17

• Aug 13, 2017

• #3

plog said:

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.

Click to expand...

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

 

Attachments

• Payoll.accdb

  1,004 KB · Views: 68

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 00:10

Joined

May 7, 2009

Messages

19,227

• Aug 13, 2017

• #4

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

 

A

aliikhlaq2006

Registered User.

Local time

Today, 20:10

Joined

Aug 10, 2017

Messages

17

• Aug 13, 2017

• #5

arnelgp said:

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

Click to expand...

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

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 00:10

Joined

May 7, 2009

Messages

19,227

• Aug 13, 2017

• #6

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

 

A

aliikhlaq2006

Registered User.

Local time

Today, 20:10

Joined

Aug 10, 2017

Messages

17

• Aug 13, 2017

• #7

arnelgp said:

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

Click to expand...

yes and i want to filter monthly

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 00:10

Joined

May 7, 2009

Messages

19,227

• Aug 13, 2017

• #8

Please try this one

 

Attachments

• Payoll.zip

  317.9 KB · Views: 82

A

aliikhlaq2006

Registered User.

Local time

Today, 20:10

Joined

Aug 10, 2017

Messages

17

• Aug 13, 2017

• #9

arnelgp said:

Please try this one

Click to expand...

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