Re: Search and compare

From: "Paul Bruneau" <paul@xxxxxxxxxxxxxxx>
Date: 5 Jul 2005 08:01:21 -0700

However, I just found out that if you do a Find for content in two
different fields in the same portal (which should be an AND find
operation), FM will return records that fit EITHER criteria (an OR
find).

I had to create a calculated field in the child file to combine the
content of the two fields, then do the Find on that.

.

Follow-Ups:
- Re: Search and compare
  - From: Matt Wills

References:
- Search and compare
  - From: D
- Re: Search and compare
  - From: D
- Re: Search and compare
  - From: Matt Wills

Prev by Date: Re: Search and compare
Next by Date: Re: Search and compare
Previous by thread: Re: Search and compare
Next by thread: Re: Search and compare
Index(es):
- Date
- Thread

Relevant Pages

How do I set criteria for calculated total fields in a query?
... In a Query I created a calculated field of cost#1.33. ... If I use no criteria I get negitive ... Prev by Date: ...
(microsoft.public.access.queries)
Re: Access Date() & DateAdd functions apparent error in Vista
... This code in both cases was placed inthe criteria grid of the query design ... I'm guessing that Access is misunderstanding the data type of something here ... a calculated field, ... If it's a text box expression, set the Format property so Access ...
(microsoft.public.access.queries)
Re: Access Date() & DateAdd functions apparent error in Vista
... you might try a compact/repair (Database Utilities on Tools ... Allen Browne - Microsoft MVP. ... This code in both cases was placed inthe criteria grid of the query design ... a calculated field, ...
(microsoft.public.access.queries)
RE: Criteria in calculated field - unexpected prompt for input
... My data type mismatch error is occuring when I enter a criteria in the ... calculated field that uses the function Datediff. ... but not in the same query that created them. ...
(microsoft.public.access.queries)
Re: Query Data Type Conversion issue with Criteria
... The next step will be to try to pin down which records give the error. ... You can test with different criteria. ... "The Frog" wrote in message ... that calculated field for filtering. ...
(comp.databases.ms-access)