Less than or equals too

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that is a calculation field in a query that gives me my
ordernow field.
I want the quantieties of the ordernow field to show up on my report only if
the ordernow field is less than or equal to my reorder_level field. How do I
write this?
 
Post the SQL statement of the current query, and we'll show you how to do
this.
 
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes
WHERE reorder_level >= ([Qty_to_Maintain]-[Physical_Count]);

--

Ken Snell
<MS ACCESS MVP>


ktfrubel said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes;


Ken Snell (MVP) said:
Post the SQL statement of the current query, and we'll show you how to do
this.
Click to expand...
Click to expand...
 
Ken,
Forgive me for sounding so ignorant, but do I add your statement exactly as
you have it here, or do I replace something? I am not very well versed in
writing in code. I added your statement and it looks just like you have it
below, but I keep getting "Characters found after End of SQL statement"

Ken Snell (MVP) said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes
WHERE reorder_level >= ([Qty_to_Maintain]-[Physical_Count]);

--

Ken Snell
<MS ACCESS MVP>


ktfrubel said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes;


Ken Snell (MVP) said:
Post the SQL statement of the current query, and we'll show you how to do
this.

--

Ken Snell
<MS ACCESS MVP>


I have a field that is a calculation field in a query that gives me my
ordernow field.
I want the quantieties of the ordernow field to show up on my report
only
if
the ordernow field is less than or equal to my reorder_level field.
How
do I
write this?
Click to expand...
Click to expand...
Click to expand...
 
Did you delete the ; character that you had after the "FROM qryShowYes"
clause? Best if you just copy my entire SQL statement and use it in place of
your original SQL statement.

--

Ken Snell
<MS ACCESS MVP>


ktfrubel said:
Ken,
Forgive me for sounding so ignorant, but do I add your statement exactly
as
you have it here, or do I replace something? I am not very well versed in
writing in code. I added your statement and it looks just like you have it
below, but I keep getting "Characters found after End of SQL statement"

Ken Snell (MVP) said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes
WHERE reorder_level >= ([Qty_to_Maintain]-[Physical_Count]);

--

Ken Snell
<MS ACCESS MVP>


ktfrubel said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes;


:

Post the SQL statement of the current query, and we'll show you how to
do
this.

--

Ken Snell
<MS ACCESS MVP>


I have a field that is a calculation field in a query that gives me
my
ordernow field.
I want the quantieties of the ordernow field to show up on my report
only
if
the ordernow field is less than or equal to my reorder_level field.
How
do I
write this?
Click to expand...
Click to expand...
Click to expand...
 
THANK YOU SO MUCH! It works perfectly!

Ken Snell (MVP) said:
Did you delete the ; character that you had after the "FROM qryShowYes"
clause? Best if you just copy my entire SQL statement and use it in place of
your original SQL statement.

--

Ken Snell
<MS ACCESS MVP>


ktfrubel said:
Ken,
Forgive me for sounding so ignorant, but do I add your statement exactly
as
you have it here, or do I replace something? I am not very well versed in
writing in code. I added your statement and it looks just like you have it
below, but I keep getting "Characters found after End of SQL statement"

Ken Snell (MVP) said:
SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes
WHERE reorder_level >= ([Qty_to_Maintain]-[Physical_Count]);

--

Ken Snell
<MS ACCESS MVP>


SELECT [Qty_to_Maintain]-[Physical_Count] AS OrderNow, qryShowYes.*
FROM qryShowYes;


:

Post the SQL statement of the current query, and we'll show you how to
do
this.

--

Ken Snell
<MS ACCESS MVP>


I have a field that is a calculation field in a query that gives me
my
ordernow field.
I want the quantieties of the ordernow field to show up on my report
only
if
the ordernow field is less than or equal to my reorder_level field.
How
do I
write this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top