How to Find morethan one Value in Same Field

[D.Santhosh]

Hi!

How will i search more than one values in same field in particular table.

For Example:

Consider the table Student

This table having three fields namely

Sno, Student Name and City like below

SNo Student Name City

========================

1 AAA XX

2 BBB XX

3 CCC YY

4 DDD ZZ

Now how will i fetch records like city=XX and YY

I tried this concepts via Relationship way mentioned below.

I created a another TABLE namely z.Globals having a calculation field namely zct.Text

Calculation : "XX ¶ YY"

And link zct.Text(z.globals) & City (Student)

Finally i got it. But if I change the value of City "YY" to "ZZ" then it will shows the city value "XX" logically its wrong because my need is if City ="XX" and "YY" but this method it shows based on condition City="XX" or "YY"

Please give me some suggestion.

Thanks

D.Santhosh

[CobaltSky]

...it will shows the city value "XX" logically its wrong because my need is if City ="XX" and "YY" but this method it shows based on condition City="XX" or "YY"

Hello D.Santhosh,

Your question is pretty confusing.

You *say* you really need to search for records where City ="XX" and "YY", but in the example you gave of the data in your table, none of the records have more than one value for City (and specifically, although there are some XXs and some YYs, there are no records with both XX and YY as the city value). So such a search would presumably return nothing. Unless, of course, your example does not accurately reflect the kind of data you want to search on...

Nevertheless, I'll endeavor to answer your question (whatever it actually may be...).

If you want to search for either XX or YY, go to find mode and enter XX into the City field, then (before performing the find) go to the Requests menu and select Add New Request. Then in the second request, enter YY into the City field. When you perform the find, records with either XX or YY will be returned.

If you really want to search for records that have both XX and YY in the city field, simply go into find mode and enter XX YY into the City field. Only records that have both XX and YY in the City field (either as separate words or on separate lines...) will be returned. If any. :wink2:

[D.Santhosh]

Dear Ray

Thanks for your response.

Actually i want to fetch records in the above example with filter condition City = "XX" and "YY" means

I want the result like below. How will i do?

SNo Student Name City

========================

1 AAA XX

2 BBB XX

3 CCC YY

[CobaltSky]

Dear Ray

Thanks for your response.

Actually i want to fetch records in the above example with filter condition City = "XX" and "YY" means

I want the result like below. How will i do?

SNo Student Name City

========================

1 AAA XX

2 BBB XX

3 CCC YY

I'm afraid you've done it again.

You say that you want the filter condition City = "XX" and "YY", then you provide an example of the result you want and it is not a City = "XX" [color:brown]and "YY" result. Instead it is a City = "XX" [color:brown]or "YY" result.

A City = "XX" and "YY" result would look like this:

SNo . . StudentName . . City . .

========================

1 . . AAA . . XX YY. .

2 . . BBB . . XX YY. .

3 . . CCC . . YY XX. .

- ie where the City field must contain both XX and YY. What you have in fact provided is an example of a result where the City field contains XX or YY.

However, as it happens, I have given you both answers already:

for City = "XX" or "YY":

If you want to search for either XX or YY, go to find mode and enter XX into the City field, then (before performing the find) go to the Requests menu and select Add New Request. Then in the second request, enter YY into the City field. When you perform the find, records with either XX or YY will be returned.

and for City = "XX" and "YY":

If you really want to search for records that have both XX and YY in the city field, simply go into find mode and enter XX YY into the City field. Only records that have both XX and YY in the City field (either as separate words or on separate lines...) will be returned. If any.

[D.Santhosh]

Dear Ray

Thanks for your response.

Ok. I will check it and get back to you later.

Thanks & Regards

D.Santhosh

[D.Santhosh]

Hi

How will i found more than one values in same field for particular table even using script or using ERD.

Consider the below table

Student name .. Subject .. Marks (out of 100)

--------------------------------------------

AAA .. Mathematics.. 90

BBB .. Science .. 60

CCC .. Mathematics.. 46

DDD .. Science .. 77

EEE .. Science .. 66

FFF .. Mathematics.. 75

In the above table i want to filter the records with the below condition

Condition:

In Subject Mathematics Marks >= 75 and

In Subject Science Marks >= 60

How will i do this?

Please help me. :

Thanks

D.Santhosh :

[Lee Smith]

IMO, it seems that you are using a lot of hypothetical for instances in your questions, which make your questions hard to understand. It may also present the wrong structure, which leads to Replies that are either unclear to you, or unusable. It is much better to use real field names, and attaching a sample file will often put the answers on a personal level for you to understand, and implement.

When I read this thread, I see a limiting structure. If your structure really is only 1 field for the Subject, and 1 field for marks. I would change this. I have found that the more you can separate your data into fields, the more flexible it is to create reports, and see what you want to see. So, I would have separate your field "Marks" into separate fields, one for each type of grade. i.e. Math_Grade, Science_Grade, English_Grade, etc.

To answer your question, you will need an "OR" find.

Enter Find Mode

Type in Subject: [color:blue]Mathematic AND type in Marks: [color:blue]≥90

[color:red]New Record Request

Type in Subject: [color:blue]Science AND type in Marks: [color:blue]≥60

Hit the [color:blue]Find button

If you had separate fields for Mathematic Marks and Science Marks, your find would be

Enter Find Mode

Mathematic Marks: [color:blue]≥90

[color:red]New Record Request

Science Marks: [color:blue]≥60

HTH

Lee

[D.Santhosh]

Dear Lee

You are Great!. Thank You so much.

Now i solve my Multi find problem.

Here with i have attached "MoreFind.zip" for your kind review.

That zip file contains the file MoreFind.fp7.

In MoreFind.fp7 having the Layouts,

Student Detail

Student List

Student Search

Now In Search page there was an Filter section and portal (Plan to show found records).

If I select particular condition and click the search button, then the "Search.." script execute the result in Student List Page.

But i want to show that found records in search page Portal how will i do?

I also try this but i can't?

Please Help me.

Many Thanks

D.Santhosh

MoreFind.zip

[Søren Dyhr]

Before you shower Lee with all the accolades, please note that Ray gave you the right answer to you question in his first reply, only you insisted on using AND/OR in vain, persistently the entire thread thru!!!

Can explain why you use AND for OR, deliberately ignoring what you're told??

--sd

[Lee Smith]

sd.

There is no need to get indigent about this member's question, or learning curve.

please note that Ray gave you the right answer to you question in his first reply

Yes he did.

However, it can be confusing to a new user when they are trying to apply them to their find. Do they use AND on one request, or an AND and an OR on one request, or combination of them on One, or Two Request.

I believe that D.Santhosh asked the question again in a different way, in hopes of clarifying things a bit in their mind. I am more tolerant of a newbee asking the same question over, and over again, in order to get it figured out, then to have someone spout their Philosophy about everything under the sun in the process of answering a question.

In other words, sd, lighten up.

Lee

[Søren Dyhr]

You're right, the question which ought to have been asked in the very beginning is whether the supposed yeild of these extra measures, would result in either more or less records ..."Expand" or "Constrain"

Maybe we should exploit your didactical skill with this thread as well. I can see from synopsis/mission statement I've recieved off forum, that a similar learning curve issue is pending:

http://www.fmforums.com/forum/showtopic.php?tid/187769/post/255401/#255401

...here!

--sd

[Lee Smith]

Hi sd.

ROTHLMAO. didactical skill, huh.

Lee

[D.Santhosh]

Dear Lee

Thank You.

Dear sd

I asked the question again in a different view because i want to Solve my doubts in any way.

More over now i found the solution.

Every one don't knows all in the world but every one try to achieve it!...

Thanks & regards

D.Santhosh

[Søren Dyhr]

Every one don't knows all in the world but every one try to achieve it!...

True, but someone who regards himself software ingineer should in my humble opinion, not be a stranger to the algebra of sets ...indeed the eager shopkeeper could be excused!

I wonder - Doesn't the terms DeMorgans Law or Associative Law ring a bell??

Let me suggest you brush it up with keen reading of this:

http://www.amazon.com/Discrete-Mathematics-New-Technology-Second/dp/0750306521/ref=sr_1_1/102-6153332-7211326?ie=UTF8&s=books&qid=1187785128&sr=1-1

--sd