Search results for query: *

I have the below formula in a report and I am trying to condition for field ({master_cred.first_name}) being null if it is null. If this field is null, the formula below will not work. Rather report brings back nothing. The report does have approx 5 parameters. One of the parameters is for...

Ok.. I know how to make union query. What do you mean by 1 as January and 2 as feb. Do you mean add that as a defining field. so I group by that.

Further, there are two groupings for each month. One for Region and another secondary for Type

I am creating a report based on an access database that has monthly data tables. I am not linking the tables and would like to create a report that shows a change in the differences between months and then show a monthly trend. What is the best way to do this. I would like to create a column...

Refer to thread 149-1529329 I follow the info but nothing is displaying from the table I wanted to flatten. The only alteration i made was to replace table and field in the accum formula. Can you explain what each formula is trying to accomplish so I can modify the accum as you suggested.

Yes . Perfect that worked. now can you just kind of summarize/explain what I did with the formula.

I have 123 bug ant 123 bug spider 123 bug worm How can I pick out records set up as above, that dont contain a corresponding field called Ant. The above would not be on the report because one of the corresponding fields is ant so I wouldnt want to see this record.

I needed to use OR because I wanted to show either this condition or that. Whatever the problem was it had to do with my Null statement. I went about a different way. I made a formula to identify string length. I then supresses that column but used selection expert to pick out only those...

(not isnull({group_detail.age_limit_code})or {vip_service.code} in ["A_CLOSED", "A_EXIST_GOLD", "A_EXIST_HW", "A_EXIST_PAT", "A_NB_EXIST_PAT"]) Something is wrong with this formula because it is still bring up records that should be eliminated with the above formula where the Length of the...

What formula would I use to determine the length of a string.

I made a formula to show my fields that are not Null or do not contain a space. But it is bringing up records that still appear NULL or contain a space. What other condition could exist in this field. If its not nul and its not a space what else could it be? Thank you

{group_detail.location} in ["MAIN"] and {master_cred.active} = "P" and {master_cred.med_staff_status} = "PCP" and (({master_cred.status} in ["ACTIVE", "part", "hold", "PRAC"] or ({log_column.initial_value}in ["ACTIVE", "PART", "HOLD", "PRAC"] and {log_column.final_value} = "inactive" and...

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

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.

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...

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.

Our system does not log span dates but rather uses on date field and when customer becomes in active we change status field and the date field . How would I use that date field to show what was active last month versus present info to get percentage diff.

The database does not keep historical span dates of active customers. When someone becomes inactive, we simply change the status date. What will be the easiest way to get number of active customers last month (by date field) and compare to current active customers by same date field

Nevermind, I believe I figured it out. Thanks!

Thanks for the reply, but I tried that with no luck. Any other suggestions? Thanks!