Search results for query: *

The value that needs to be counted, or what I've been counting, is a distinct count of App#s. Or the number of households served during that time period, grouped by counselor. Basically, the report is showing that a household (app#), received services (ActivityDate) during a certain time...

Using CRXI and a SQL2K8 db. This seems pretty simple, but for the life of me, I can't figure it out - searched the forum so if I missed the answer, I apologize for the clutter. Trying to return and summarize 1 record per group. 3 fields: App#, ActivityDate, Operator For each App# there are...

They are duplicates because under the same partid grouping (145789), the merchant id, check date, check number and check amount all match. The RCID is assigned at the time the record is created, like a sequential row number or reference number.

Here's my dilemna - I need to see the duplicate records for a person - both the original AND the duplicate. This person may have multiple records, but only 1 is duplicated, and those are the only ones I want to see to determine if it is a true duplicate and remove the record from the database...

Anyone know why the option to export to an MS Access Database is no longer listed in the drop down box for exporting? I have it set up as a system dsn, but it does not appear as an option to export. Any clues greatly appreciated - have spent way too much time on this!

Thanks!!

Forgot to add - there is only one group, but one letter per group, using a date range to print letters. Tried moving the formula to the group header instead, but no go.

Okay, here is the formula now. The address prints now, except that if a field is blank, the last record is read and the data pulled and added to each record until it comes upon a field with a new value in it. For example: 125 Main #105 (correct address) 456 Oak #105 (although no apt number in...

There are blank fields (not every street is N, S, E, W, and not everyone lives in an apt, etc.). It appears that if one field in the formula is blank, nothing prints. The whole line is blank. I don't know if this makes a difference, but the formula is in the page header.

Thank you - I'm getting some records, at least, but still getting plenty of blank lines where the address should be.

I am attempting to join multiple fields in a formula, but am getting blank lines when there is no data in one field. This is for an address and the formula created is pretty simple: {POPPPR.PB_ADR_STNO}+ " " + {POPPPR.PB_ADR_DIR1} + " " + {POPPPR.PB_ADR_STR1}+ " &quot...

I'm getting a CacheServer and PageServer error when trying to install CE8. According to the services, the dependencies are running, but the cache service won't run. Any ideas???