Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-12-2017, 12:33 PM   #1
aliikhlaq2006
Newly Registered User
 
Join Date: Aug 2017
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
aliikhlaq2006 is on a distinguished road
Filter in expression builder

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

aliikhlaq2006 is offline   Reply With Quote
Old 08-12-2017, 02:37 PM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,288
Thanks: 10
Thanked 1,993 Times in 1,954 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Filter in expression builder

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.
plog is offline   Reply With Quote
Old 08-13-2017, 02:57 AM   #3
aliikhlaq2006
Newly Registered User
 
Join Date: Aug 2017
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
aliikhlaq2006 is on a distinguished road
Re: Filter in expression builder

Quote:
Originally Posted by plog View Post
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
Attached Files
File Type: accdb Payoll.accdb (1,004.0 KB, 13 views)

aliikhlaq2006 is offline   Reply With Quote
Old 08-13-2017, 03:14 AM   #4
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,699
Thanks: 49
Thanked 1,566 Times in 1,492 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: Filter in expression builder

What kind of parameter is to be inputted. Please be specific.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-13-2017, 03:21 AM   #5
aliikhlaq2006
Newly Registered User
 
Join Date: Aug 2017
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
aliikhlaq2006 is on a distinguished road
Re: Filter in expression builder

Quote:
Originally Posted by arnelgp View Post
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
aliikhlaq2006 is offline   Reply With Quote
Old 08-13-2017, 05:05 AM   #6
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,699
Thanks: 49
Thanked 1,566 Times in 1,492 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: Filter in expression builder

This calculated column is for OT Pay only, is this correct?
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-13-2017, 07:32 AM   #7
aliikhlaq2006
Newly Registered User
 
Join Date: Aug 2017
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
aliikhlaq2006 is on a distinguished road
Re: Filter in expression builder

Quote:
Originally Posted by arnelgp View Post
This calculated column is for OT Pay only, is this correct?
yes and i want to filter monthly

aliikhlaq2006 is offline   Reply With Quote
Old 08-13-2017, 07:56 AM   #8
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,699
Thanks: 49
Thanked 1,566 Times in 1,492 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: Filter in expression builder

Please try this one
Attached Files
File Type: zip Payoll.zip (317.9 KB, 15 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
aliikhlaq2006 (08-13-2017)
Old 08-13-2017, 02:06 PM   #9
aliikhlaq2006
Newly Registered User
 
Join Date: Aug 2017
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
aliikhlaq2006 is on a distinguished road
Re: Filter in expression builder

Quote:
Originally Posted by arnelgp View Post
Please try this one
It worked for me and i have seen that you put where in the overtime query and a parameter

aliikhlaq2006 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Expression Builder Expression Not Summing lhooker Forms 5 03-13-2015 05:42 PM
Question From Expression builder to Code builder MrNooby General 18 03-05-2010 01:17 AM
how to shorten my expression in expression builder anski General 2 11-11-2009 02:59 AM
Need Help on building an expression, first time expression builder. dxqwest Modules & VBA 7 08-24-2001 05:00 PM
Need Help on building an expression, first time expression builder dxqwest Queries 2 08-22-2001 10:12 AM




All times are GMT -8. The time now is 05:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World