"average" problem

[patriot76]

In my query I ask for Average wk movement and I put in for criteria [enter,"<"]. When I run the query a window pops up asking for a figure. For example I will put a 10. This should return me all the records that have less than 10. The query only returns the records that are exactly 10. What I'm I doing wrong with the criteria?

patriot76

 

[grnzbra]

I think the quotation marks are causing Access to think that the < is an alpha character rather than an operator.

 

[patriot76]

"average" issue

grnzbra

I took the quotes out, but it still returns all records that are exactly 10?

did not work.

patriot76

 

[grnzbra]

Can you post the sql statement here, or at least the WHERE clause?

 

[raskew]

Hi -

Your operator belongs outside the parameter.

< [enter]

e.g.

SELECT Orders.OrderID, Orders.CustomerID, Orders.Freight
FROM Orders
WHERE (((Orders.Freight)<[enter]))
ORDER BY Orders.Freight DESC;

HTH - Bob

 

[patriot76]

"average problem

This is the SQL statement, if I move the brackets in the last enter it still doesn't work.

SELECT MovementF.Description, MovementF.ITEM, MovementF.SLOT, MovementF.[AVG-WK]
FROM MovementF
WHERE (((MovementF.SLOT) Between [Enter Begin Loc] And [Enter End Loc]) AND ((MovementF.[AVG-WK])=[Enter "=<"]))
ORDER BY MovementF.SLOT;

Patriot76

 

[grnzbra]

Your SQL statement is asking for all equal to whatever is entered.

Should be

AND ((MovementF.[AVG-WK])<=[Enter "=<"]))

 

[patriot76]

"average problem"

grnzbra

Plug the new Sql statement in with the correction and it works great.

Thank you so much!

Patriot76