Search results for query: *

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?

Thank you, I will try your suggestion, and check out the perfomance info

Is there a way to put a formula on the report that will give how long the report took to finish? I'm trying a few methods to speed up my reports, but need a method to verify the changes. Thanks in advance

Is there a way in SQL to show the end user a message as parts of the SQL script complete? I'm using WinSQL if it helps.... Thanks in advance

Hello, I'm using CR XI SP2, as I tried to create a new report today, I am unable to manually link keys in tables. It will do the auto link, but I need to drag and drop links. It worked yesterday... I've uninstalled and re-installed, still same issue. Thanks in advance Bob

Hello, We're using Office 2003, excel, word etc always ask me if I want to save the current copy when I close, even if I have not made any changes. This even happens on a document that I have previously opened and saved. Any way to turn that off? Thanks in advance