Query NOT taking the two parameters WHY?

[iamraja5]

Hi All

I have a access 2007 form with two objects,
1) One combo Box with two operators I.e Less than < and > greater than Sign.
2) second Text Object with Qty I.e 50

All I am doing here is, the user can select greater than or less than sign and enter his/own qty for search

In the qty query field,
I have done like this,


>[Forms]![TAN Main]![units]

this is workign only if I hard coded the operator >, I want to select both the operator sign and the qty to gather. How do I connect both form objects in a query?

Please help
Thank you

[llkhoutx]

It's impossible to give you advice without the actual problematic query.

[iamraja5]

Hi Here is the query,
>[Forms]![TAN Main]![units]

">" is the greater than sign or "<" less then sign is coming from a combo box in the form where user can select, and units in the text box in the form as well.

I have hard coded the ">" , how I can enter in the query block togather with
[Forms]![TAN Main]![units]

I tired this way
[Forms]![TAN Main]![operato] & [Forms]![TAN Main]![units]

I got the error msg as " you have tried a complex mathematicl,,simplify"

I know I am missing something, but not sure what it is..

Please help.

Raja

[llkhoutx]

Try this:

chr(34) & [Forms]![TAN Main]![operato] & chr(34) & [Forms]![TAN Main]![units] 

that is, enclose a string reference in quotation marks.

[iamraja5]

mmm, I tired
Chr(34) & [Forms]![TAN Main]![operato] & Chr(34) & [Forms]![TAN Main]![units]

Still got the same error msg." too complex to evaluate...."

any other method?
thanks

[llkhoutx]

What is the entire SQL string of your query? You've only provided part of a filter.

[iamraja5]

Hi
Here is the SQL code
SELECT DISTINCT Sum(MARC_LOAD.QTY) AS SumOfQTY
FROM MARC_LOAD INNER JOIN MARC_CONTAINER ON MARC_LOAD.CONT_NO = MARC_CONTAINER.CONT_NO
HAVING (((Sum(MARC_LOAD.QTY))=Chr(34) & [Forms]![TAN Main]![operato] & Chr(34) & [Forms]![TAN Main]![units]));



Thanks

[iamraja5]

Hi all

I have attached the Database. The Query is still erroring out.
The user will select the operator ( i.e Greater than or less than, etc) and will enter the units in the form.

when hit the submit, there is a query running. The query is not taking the two selections(parameter) from the form.

Please help me how to enter the criteria linked to he form?

thanks alot