Find BY Form

[julian lewis]

I have a field named "equity"

Some people do not have equity so it reads ie. (3000.00)
People with equity reads ie. 5000.00

I have tried to do a find like this

"-3000.00"100.00 (greater than negative 3000.00 and Less than negative 100.00

It wont let me do it. It just gives me everyone who is Greater than -3000.00

Thanks so much
jc

[Tom Cone Jr]

RE: Find BY Form

"pre"
Equity "= -3000 .and. Equity "= -100

"/pre"

The Between() function is also useful here.

-- tom

[Tom Cone Jr]

RE: Find BY Form

Oops. Please ignore the previous. Thought you were running a query. See now you're doing a Find by Form.
Sorry.

-- tom

[julian lewis]

RE: Find BY Form

Tom:

Are you doing this in "Find by Form"?

Thanks
jc

[Tom Cone Jr]

RE: Find BY Form

Julian,

I don't think Find By Form will let you enter a compound expression as a search key.

I'd recommend you use Query By Form, instead. This will filter the current table so that only records matching the search criteria will be visible. Check the User Guide discussion of "Query Operators" and you'll find a robust collection available for you.

-- tom

[julian lewis]

RE: Find BY Form

Tom:

What I was really trying to accomplish was a button to automatically return the "=-3000.00 and "=-100.00 group of records with no input from the user. Also, the "equity" field is a calculated field

Any ideas?

Thanks
jc

[Al Buchholz]

RE: Find BY Form

Julian

Use a saved query. You make the query and then save it and have the button refer to it.

[julian lewis]

RE: Find BY Form

Al:


Where do you start to set up the query to "save" and will it let me query on a calculated field.

Thanks
jc

[julian lewis]

RE: Find BY Form

Okay, I tried running a "saved query" but, I need to query on a calculated field, which does not show up in my list of field options.

Thanks
jc

[Al Buchholz]

RE: Find BY Form

Julian

I don't recall a mention of a calculated field prior to this.

Please post an example of the database and tables so we can be on the same level.

[julian lewis]

RE: Find BY Form

Al:

I have a tbl. for the customers. I has three fields on it.

Payoff, Value, and Equity.

Payoff-Value=Equity


I want to build a saved query where it will return the customers who are "=(3000.00)"=(100.00)

Thanks
jc

[julian lewis]

RE: Find BY Form

This one has me really stumped, if anyone knows the answer.

Thanks so much
JC

[Tom Cone Jr]

RE: Find BY Form

Julian,

Unless negative equity is a good thing, shouldn't it be:

Value - payoff = equity

???

Do you have a sample table we can play with?

-- tom

[Tom Cone Jr]

RE: Find BY Form

Julian,

Unzip the attachment to an empty folder.

You'll find a simple one table database. The saved query operation is on the Operations tab of the control panel. When run it filters the table to show only records where the Equity field has values lying in the range from -3000 to -100.

This example was built with A5V5 but should run just fine under A5V6.

-- tom

[julian lewis]

RE: Find BY Form

Tomn:

Thanks so much, Negative equity is a bad thing, but: 90% of the people who trade cars in have it.

Thanks
jc