Recent content by bdjb

It's just a standard Find Duplicates query at this point, which does pull in the data wanted, but then some, as invoices can have several entries of pending, and none with paid. So I just want to see those that have multiple entries, and where at least one of them are paid for the status SELECT...

Hello, I have an Access find duplicates query, that part works fine. It pulls in invoices that can be entered multiple times... once with Processing, Payment Processing or Paid as a status. How can I set the query to only pull in Duplicates for the Invoice field, and those that also have paid or...

Hello, The security method can be used with newer versions as long as you don't upgrade the old DB. Yes, we use the shortcut method to reference the workgroup. We have added the user to the Admins group, but it doesn't seem to do anything.

We hacve an access DB that was created in '97, but are currently using 2010. The user level security wizard was used to lock down the DB, but the person who did it is on extended medical leave. We used the User and Group permissions wizrd to add a new user, and is seems to complete, but that...

Thanks LB, I have a listing of Clients for the rows, then count of files by Office and state Chicago Cinci IL IN OH Client1 15 3 5 Client2 7 1 4 Client3 12 12 5 Client4 8 3 22 The group...

OK. so group selection formulas are ignored by the crosstab?

Thanks for the reply, I'm not suppressing anything in the details, only using the select statements. If I select only OH files in my selection statement, I get just OH, but in the cross tab, I'll get all states if that makes sense?

How can I create a cross tab in Crystal 11 that won't ignore the overall Selection Criteria? When run, the detail data is correct, but the Cross Tab pulls in everything thanks in advance

Sorry, On .Rows(sRow & ":" & sMaxRows).Delete

Hi Skip, I get an error "Run-Time error '13" Type Mismatch" on your code. I'm running Office 2003. Any ideas? Thanks Bob

Thank you, that gave me the answer I needed. When run anytime during the current month, it will give the next full month plus 14 days {TODOAPPT.StartDtAct} In dateadd("M",1, minimum(MonthToDate)) to dateadd("M",2, minimum(MonthToDate)) + 14

I am pulling data based upon a date field, now they would like the next full month, plus 14 days (so basically a month and a half). Any pointers on how to do that based upon a date field? Thanks in advance!

Hello, The {@investor type} formula just identifies a particular field from the DB. We're pulling data based upon a particular investor (FHLMC). Fileds in the main report are the CLient, Office Name, and file numbers that the crosstab should be counting. The crosstab is located in the group footer

Hi LB, Yes, you are right, I do have a group selection formuls. I didn't realize the crosstab processed earlier. Row = Client Name Column = Office.FirstName Summary = Count of Entities.EntityID Group Selction = Maximum ({@Investor_Type}, {Entities.EntityID}) in ["FHLMC"] Thank you very much

I have a report, the records shown in the detail section are being limited by the selection formulas, but the crosstab seems to pull in all data, there are records in the crosstab that aren't in the details area. Any ideas of why this might be?