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.
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.
(
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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.