Less than or equals too

[ktfrubel]

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?

 

[Ken Snell \(MVP\)]

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

 

[ktfrubel]

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

 

[Ken Snell \(MVP\)]

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.

 

[ktfrubel]

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"

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?

 

[Ken Snell \(MVP\)]

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>

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"

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?

 

[ktfrubel]

THANK YOU SO MUCH! It works perfectly!

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>

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"

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?