Query Question - How do I write an expression in Criteria

[PhoneTech2]

I want to run a query with the results based on a value in a table not part of the query.

The table has only one record called MINIMUM

What is the format for such a critera, I have tried variations on the following:

=table!TableName!FieldName

But no matter how I write it, when I run the query it ask me to enter a value for FieldName.

Can someone show me the proper way to write the expression so that the query will look up the value.

Thank you.

 

[FCCC]

Try this....

=table!TableName!ControlName

Change your FieldName with your ControlName.

Hope this helps.

 

[PhoneTech2]

FCCC

I am sorry. But I do not know what you mean by ControlName.

The table has only one field, and only one record. The table name is VMLimits and the Field name is Minimum.

Can you give me just another hint?

Thank you

 

[FCCC]

How do you run this code? Are you using a form or a report?

 

[PhoneTech2]

I am clicking on the run ( ! ) command on the tool bar. When I get it working, it will be in a Report.

 

[FCCC]

why don't you just put ="MINIMUM" on your query field. Please try if this is what you are trying to do.

 

[PhoneTech2]

I did not know you could do that.

I added the VMLimit table to the query.

I put the one field (minimum) into the query.

Under criteria I entered >=[minimum], and it worked.

Thank you

 

[FCCC]

Great to hear it worked.