greater than without using ">" (1 Viewer)

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
hi guys, i have this Hard Question that i have to solve and submit it today

ti's about this database

i want to see all employees who have salary more than “Saleh’s salary”. with out USE “>21,450”
Because Salah's salary can change in the future

Thanks in advance
 

Attachments

  • access11.png
    access11.png
    34.4 KB · Views: 77

Gasman

Enthusiastic Amateur
Local time
Today, 20:44
Joined
Sep 21, 2011
Messages
14,047
Don't hard code values, then it does not matter what salary Salah has.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:44
Joined
Oct 29, 2018
Messages
21,358
Hi. Is this a homework assignment? Your topic title says without using ">," but I think you can't avoid that if you want to know greater than values. I think it's more like you don't want a fix value like 21,450, which means you should be able to use >[Salary].
 
Last edited:

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
yes it is assignment, and i don't konw how to do it.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:44
Joined
Oct 29, 2018
Messages
21,358
Hi. Since we are not familiar with the requirements of the assignment, it might be faster to get an answer if you asked one of your classmates. If you need help from us, we'll need to see what you've tried, so we can help you fix it. Can you tell us the stated goal for the homework? Thanks.
 

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
Hi. Since we are not familiar with the requirements of the assignment, it might be faster to get an answer if you asked one of your classmates. If you need help from us, we'll need to see what you've tried, so we can help you fix it. Can you tell us the stated goal for the homework? Thanks.

as i know there is no one solve it until now, the assignment is like A set of questions about how to create queries, i did a lot but i doesn't related to this question.
 

Mark_

Longboard on the internet
Local time
Today, 13:44
Joined
Sep 12, 2017
Messages
2,111
Can you create a query of everyone who has a salary equal to or less than the selected employee's salary?

Can you create a second query that includes all employees EXCEPT those in the first?
 

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
Can you create a query of everyone who has a salary equal to or less than the selected employee's salary?

Can you create a second query that includes all employees EXCEPT those in the first?


yes i can, hmmmm
 

Minty

AWF VIP
Local time
Today, 20:44
Joined
Jul 26, 2013
Messages
10,355
Put the first query in the second query in the designer .

Mess around with joins and Is Null criteria.

If the world stops spinning you know you broke the interwebs.
 

George21

Registered User.
Local time
Today, 22:44
Joined
Jan 10, 2011
Messages
27
Will Saleh be a constant (meaning the criteria won't be changed in the future)? If so, create a query based on the table and in the emp_salary criteria write foll:

>DLookup("emp_salary","emp_table","emp_id = 8")
 

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
Will Saleh be a constant (meaning the criteria won't be changed in the future)? If so, create a query based on the table and in the emp_salary criteria write foll:

>DLookup("emp_salary","emp_table","emp_id = 8")

no the salary it might be changed
 

aqeelh

New member
Local time
Today, 13:44
Joined
Feb 13, 2019
Messages
7
i think i have to work with Nested Queries but how i write criteria without writing employee's salary
 

plog

Banishment Pending
Local time
Today, 15:44
Joined
May 11, 2011
Messages
11,611
no the salary it might be changed

No, he didn't ask that. He asked if Saleh was the constant in the equation, not Saleh's salary. My opinion is you totally botched the purpose of this assignment and focused on the '>' part when the real part the teacher wanted you to avoid was the '21450'.

George21 provided the correct solution.
 

Users who are viewing this thread

Top Bottom