Using formula expert as selection expert

[tcbc]

I would like to use formula expert as selection expert for two groups. What kind of statement would I use so that the formula expert selects the correct records but doesnt demand a typical formula operator.

 

[IanWaterman]

You are going to have to give an example, as it is not clear what you are trying to achieve.

Ian

 

[tcbc]

Let me explain further.
id type sub type status date
123 Cat Domestic active 01/01/2008
456 cat long hair Inactive 02/24/09

I want two columns

first to list active second to list ones the were active last month. Above are the fields available. So the first column will only show the first record but the second will show the first and second record. Or if we cant do by columns, how about two detail sections with a forumula that picks out the above. Cant use selection expert to separate the two.

 

[IanWaterman]

you can filter in select expert

(
Status = active or
yourdatefield <= Date(Year(dateadd("m", -1, currentdate),
month(dateadd("m", -1, currentdate), 01)
)
Wrapping in brackets allows inclusion in existing select criteria.

Ian

 

[tcbc]

But how will that separate the two comparison sets I need.

One of those that were active last month versus those that are currently active. I kind of follow what you are saying but it appears to only give me the one set.

 

[IanWaterman]

Understand what you want (I think).

Use a min report with a subreport.

Main report list only active accounts, and place to left of page.

In report header place a subreport to the right hand side of page which lists your inactive accounts. In Rep Hdr section expert check underlay following sections.

Ian

 

[tcbc]

What do you mean by min report? I get the sub and underlay

 

[IanWaterman]

So typo! Should say main report.

Ian